Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Thursday, November 12, 2015 7:27 AM
Points: 5, Visits: 117
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: Wednesday, May 18, 2016 12:48 PM
Points: 1,255, Visits: 1,442
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
Posted Wednesday, May 18, 2016 7:14 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:21 AM
Points: 7,814, Visits: 752
Thanks for the script.
Post #1787261
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse