View Stored Procedures with Transact SQL

[Helmut Pfundner]

Hi

Does anyone the syntax or command to View Stored Procedures with Transact SQL statement. I have tried using the syscomments but there is some information missing.

I would appreciate any reply !

Thanks you for your time.

[Cindy]

From SQL Enterprise Manager you can generate the scripts for the stored procedures or drill down through the server manager to the server.database.object.storedprocedure.

Or sp_helptext {storproc name} - this does a carriage return/line feed after every 255 characters.


------------
Helmut Pfundner at 5/25/99 1:04:21 PM

Hi

Does anyone the syntax or command to View Stored Procedures with Transact SQL statement. I have tried using the syscomments but there is some information missing.

I would appreciate any reply !

Thanks you for your time.