Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

unable to see comments in store procedure Expand / Collapse
Author
Message
Posted Wednesday, September 23, 2009 4:45 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, November 14, 2013 7:42 PM
Points: 326, Visits: 393
hi all ,

i have written a store procedure as follows

--procedure name usp_get_date
--Author Ramu
--Script Date 12/09/2009
create procedure usp_getdate
as
begin
select getdate();
end

few back i was able to see my comments written create statement. but now i cant find them what be the reason behind it.

Regards
Ramu
Post #792514
Posted Wednesday, September 23, 2009 6:04 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,068, Visits: 4,639
how about putting the comments inside the storedproc instead of outside of it?

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Post #792551
Posted Wednesday, September 23, 2009 6:34 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, November 14, 2013 7:42 PM
Points: 326, Visits: 393
ya i have did that. but its strange that i cant see the comments as wanted earlier.
if use 2005 SSMS to modify the sp i cant the comments. where as if use 2008 ssms i can see comments its very strange
Post #792565
Posted Wednesday, September 23, 2009 7:14 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 4:02 PM
Points: 33,062, Visits: 15,176
I wouldn't expect comments outside of a proc to show up. I might run a lot of stuff in a window, and wouldn't necessarily want other items in a batch to be compiled to the stored proc.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #792600
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse