Showing posts with label click. Show all posts
Showing posts with label click. Show all posts

Monday, March 26, 2012

properties on stored procedure

Hey

I have a problem viewing properties on my stored procudures, when i right click there is no properties button like in the other versions, is that a bug ?

hi,

if you mean "extended properties" of a specified object, you can access them right clicking the relative object in SQL Server Management Studio (or SQL Server Management Studio Express) and accessing the last "tab" (Extended Properties tab.. ok, it' no longer a tab, but hope you understand what I mean )

regards

Monday, February 20, 2012

Programatically deploying reports

Hi All,

I want to programatically deploy the report in VS2005 environment,ie.from an asp.net page if i click deploy report Button ,the report should be deployed into the report server automatically.So that i can view the report in report server.
the input to the asp page would be the.rdl file...
If anyone could help then it would be good.

thankyou.


See the sample here:

http://www.codeproject.com/sqlrs/SQLReportDeploy.asp

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Jens,

Thanks for the link! I posted a similar question twice in the past couple of weeks without a response and now I have one!

|||I was tired watching the Reporting Services groups, but now I am planning to visit it more regulary. :-)

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

Another way of doing this can be found out at

http://sqlblog.com/blogs/rhundhausen/archive/2006/12/26/deploy-rdl-files-to-multiple-sql-server-2005-reporting-services-servers.aspx

check it out this really works.