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

Retreive the Schema of a Stored Procedure or Function Expand / Collapse
Author
Message
Posted Tuesday, September 7, 2010 9:05 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 25, 2014 5:24 AM
Points: 4, Visits: 107
Comments posted to this topic are about the item Retreive the Schema of a Stored Procedure or Function
Post #982013
Posted Thursday, September 9, 2010 6:34 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 9:43 AM
Points: 1,221, Visits: 1,299
This doesn't return the schema of a preocedure. It returns the parameters

For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #983037
Posted Thursday, September 9, 2010 11:51 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 11, 2011 10:52 AM
Points: 6, Visits: 84
Why not just use sp_helptext?
Post #983344
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse