Join | Login | Why Join?   
SQL Server, Oracle, DB2, Sybase, MySQL Help - SSWUG.ORG HACKER SAFE certified sites prevent over 99.9% of hacker crime.
Search SSWUG:   
 
Access to 474 free guest articles, discussions and more, just create your free SSWUG User ID:
Email address:  
This will be your login ID - we'll email you your password - you'll even receive the newsletter, opt-out at any time.
Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

Full site membership is required for this article. Already a full member? Login here.
You currently have a guest membership. You can upgrade to full site membership here (free trial available).

View the source code of a stored procedure in Yukon


 Article Abstract:

(Vadivel Mohanakrishnan) In this article let us look into the way of displaying the definition of user defined stored procedure and system stored procedure in Yukon (code name of Sql Server 2005).

In Sql Server 2000 we would use sp_helptext to view the source code of both user defined and system stored procedure. But that is in't completely true in Yukon.

 Read this article...
 Related Articles - For Members.
All Articles By Author

What is OBJECT_ID in SQL Server?
There is still stuff I hadn't noticed (OBJECT_ID has a parameter for type of object)
SQL Server 2000 useful undocumented stored procedures
Find tables which don't have Primary Key
Get the specific column type procedure
Find whether a column is identity or not ...
Quick search within ALL stored procedures ...
Useful code snippets for Beginners



Key (Please note):
(R) - registration may be required for access at the target site
($) - target site may require paid membership for access to this or other content

No Comments/Feedback Posted Yet. Post Your Comments/Feedback

Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

   



 

[ Register ] [ Webcasts ] [ Podcasts ] [ Newsletter Archive ] [ RSS/Feeds ]
[ About ] [ Advertise ] [ Contact ] [ Privacy ] [ Terms of Service ]
[ Link to SSWUG ] [ List Server Archives ] [ Recent Orig. Content ]
(c) 1997-2008, Bits on the Wire, Inc.  (0)

Some names and products covered by SSWUG are the registered trademarks of their respective owners.
DAA10354WWW004