November 22, 2002 at 2:11 pm
Here goes. What I need to do is extract stored procedure comments. SELECT text FROM SYSCOMMENTS seems to cut off after so many characters. Anyone done this with TSQL, SQL-DMO, a VB program?
I need something to extract all rows that start with:
a. CREATE PROCEDURE
b. /*
c. **
d. */
e. --
Be great!
Michael
Be great!
Michael
November 22, 2002 at 4:14 pm
using query analyser will cut of text according to the setting in query Analyser| options (SET TEXTSIZE as well)
Have a look at my stored procedure to script a stored procedure
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=585
a row in syscommments does not equate to a line in the stored procedure. So you will need to do some checking for char(10) and char(13)
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
November 22, 2002 at 7:25 pm
Even after setting the text size it does not give the complete text of the stored procedure,I chops off the text in a single row after certain limit.For example if you have a lengthy query in a single line it chops off after certain length.
November 23, 2002 at 3:56 am
what are you trying to achieve?
Did you set it in the options of Query analyser and if so what did you set it to
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply