What’s the fastest animal on earth? The Cheetah.
What’s the fastest way to get a definition of a unencrypted stored procedure? Use SP_HELPTEXT
- unencrypted stored procedure
- user-defined function
- user-defined rule
- computed column
- CHECK constraint
- system object
Here’s an example from the AdventureWorks database…..
Here are some related posts from the intraweb:
- I found an article from Jason Strate here: I don’t Want To Use the Object Browser (sp_helptext)
- A couple good alternatives from Belle’s SQL Musings here: How to Get Definition for Stored Procedures, UDFs and Triggers using T-SQL