Showing posts with label window. Show all posts
Showing posts with label window. Show all posts

Thursday, March 29, 2012

getting a stored procedures code

I don't know if this is possible. However, what i am attempting to do is
using C#'s window forms. I open up an excell sheet stored in my windows
form. The excel sheet stores names of the stored procedures in that
database. I want to know if it's possible to click on that stored
procedure to open up a link to display the code of that stored procedure of
course in a read only mode.

any suggestions...Two possible options: Query the syscomments table (See Books Online for
details) or use the Script method in the SQLDMO API (a COM API, not
..NET).

--
David Portas
SQL Server MVP
--|||using sp_helptext <Stored Procedure Name>
enables you to see the stored procedure code

best Regards,
Chandra
http://groups.msn.com/SQLResource/
http://chanduas.blogspot.com/
------------

*** Sent via Developersdex http://www.developersdex.com ***sql

Friday, March 23, 2012

GetImage=8.00.878.00f1_rsc_htmlviewer.html

Hi
I am trying to get the HTML viewer help file to appear. When I click the
help icon I go get a new window with the URL
http://myserver1/ReportServer?rs:Command=Get&rc:GetImage=8.00.878.00f1_rsc_htmlviewer.htm
which is blank ( file exixts on the server )
when I goto another server
http://myserver2/ReportServer?rs:Command=Get&rc:GetImage=8.00.878.00f1_rsc_htmlviewer.htm
the file pops right up.
I have changed some of the report renderings on both servers 1 & 2
( Identical changes ).
THere is no documentation that really helps here ( especially if 8.00.878.00
is getting the english language version)
Do I have to set some language setting in RS ?
TIA
Ray
--
Illusion is the first of all pleasures.I can't really think of a reason why you would not see the file. Here are
some things you can try:
Try a ctrl-F5 refresh, the help page is set to live on the client for 30
days, perhaps the client copy is corrupt.
Ensure each language folder has the help file and that they are not blank.
As for the language, RS will query the browser language and select the help
file based on that. If the language is not supported then you should get
English.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"punchcardRay" <punchcardRay@.discussions.microsoft.com> wrote in message
news:42B3F70D-1383-4789-8CF1-9091C20DAFC7@.microsoft.com...
> Hi
> I am trying to get the HTML viewer help file to appear. When I click the
> help icon I go get a new window with the URL
>
http://myserver1/ReportServer?rs:Command=Get&rc:GetImage=8.00.878.00f1_rsc_htmlviewer.htm
> which is blank ( file exixts on the server )
> when I goto another server
>
http://myserver2/ReportServer?rs:Command=Get&rc:GetImage=8.00.878.00f1_rsc_htmlviewer.htm
> the file pops right up.
> I have changed some of the report renderings on both servers 1 & 2
> ( Identical changes ).
> THere is no documentation that really helps here ( especially if
8.00.878.00
> is getting the english language version)
> Do I have to set some language setting in RS ?
> TIA
> Ray
>
> --
> Illusion is the first of all pleasures.|||Daniel
I did the refresh with no luck, I also checked to make sure the files were
there and they were. I have seen two other posts that were basically the same
as mine, is this issue on a defect list ?
Ray
"Daniel Reib [MSFT]" wrote:
> I can't really think of a reason why you would not see the file. Here are
> some things you can try:
> Try a ctrl-F5 refresh, the help page is set to live on the client for 30
> days, perhaps the client copy is corrupt.
> Ensure each language folder has the help file and that they are not blank.
> As for the language, RS will query the browser language and select the help
> file based on that. If the language is not supported then you should get
> English.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "punchcardRay" <punchcardRay@.discussions.microsoft.com> wrote in message
> news:42B3F70D-1383-4789-8CF1-9091C20DAFC7@.microsoft.com...
> > Hi
> > I am trying to get the HTML viewer help file to appear. When I click the
> > help icon I go get a new window with the URL
> >
> http://myserver1/ReportServer?rs:Command=Get&rc:GetImage=8.00.878.00f1_rsc_htmlviewer.htm
> > which is blank ( file exixts on the server )
> > when I goto another server
> >
> http://myserver2/ReportServer?rs:Command=Get&rc:GetImage=8.00.878.00f1_rsc_htmlviewer.htm
> > the file pops right up.
> >
> > I have changed some of the report renderings on both servers 1 & 2
> > ( Identical changes ).
> > THere is no documentation that really helps here ( especially if
> 8.00.878.00
> > is getting the english language version)
> > Do I have to set some language setting in RS ?
> >
> > TIA
> > Ray
> >
> >
> >
> > --
> > Illusion is the first of all pleasures.
>
>|||I'm not sure what would cause this behavior. I will investigate this
further and see if I can come up with a resolution.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"punchcardRay" <punchcardRay@.discussions.microsoft.com> wrote in message
news:65BA2102-916C-4879-A99D-EFA6DD59E7F0@.microsoft.com...
> Daniel
> I did the refresh with no luck, I also checked to make sure the files were
> there and they were. I have seen two other posts that were basically the
same
> as mine, is this issue on a defect list ?
> Ray
>
> "Daniel Reib [MSFT]" wrote:
> > I can't really think of a reason why you would not see the file. Here
are
> > some things you can try:
> >
> > Try a ctrl-F5 refresh, the help page is set to live on the client for 30
> > days, perhaps the client copy is corrupt.
> >
> > Ensure each language folder has the help file and that they are not
blank.
> >
> > As for the language, RS will query the browser language and select the
help
> > file based on that. If the language is not supported then you should
get
> > English.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "punchcardRay" <punchcardRay@.discussions.microsoft.com> wrote in message
> > news:42B3F70D-1383-4789-8CF1-9091C20DAFC7@.microsoft.com...
> > > Hi
> > > I am trying to get the HTML viewer help file to appear. When I click
the
> > > help icon I go get a new window with the URL
> > >
> >
http://myserver1/ReportServer?rs:Command=Get&rc:GetImage=8.00.878.00f1_rsc_htmlviewer.htm
> > > which is blank ( file exixts on the server )
> > > when I goto another server
> > >
> >
http://myserver2/ReportServer?rs:Command=Get&rc:GetImage=8.00.878.00f1_rsc_htmlviewer.htm
> > > the file pops right up.
> > >
> > > I have changed some of the report renderings on both servers 1 & 2
> > > ( Identical changes ).
> > > THere is no documentation that really helps here ( especially if
> > 8.00.878.00
> > > is getting the english language version)
> > > Do I have to set some language setting in RS ?
> > >
> > > TIA
> > > Ray
> > >
> > >
> > >
> > > --
> > > Illusion is the first of all pleasures.
> >
> >
> >sql