Friday, June 15, 2012

SQL SERVER – Stored Procedure to display code (text) of Stored Procedure, Trigger, View or Object

This is another popular question I receive. How to see text/content/code of Stored Procedure. System stored procedure that prints the text of a rule, a default, or an unencrypted stored procedure, user-defined function, trigger, or view.

Syntax sp_helptext @objname = 'name'

sp_helptext [ @objname = ] 'name' [ , [ @columnname = ] computed_column_name

Displaying the definition of a trigger or stored procedure sp_helptext 'dbo.nameofsp'


2 comments:

  1. My brother rесommended I might like this wеbsite.
    He was totаlly right. This poѕt tгuly maԁe my daу.
    Yοu сan nοt іmagine just how much time I
    had spent for this info! Thanks!
    Also see my page :: PlayStation 3 Cheats

    ReplyDelete
  2. Magnificеnt goods fгom you, man. I've understand your stuff previous to and you are just extremely great. I actually like what you've aсquired heгe, really likе what you are sаying
    and the way in which yοu say it. You maκe it entertaining anԁ
    уou still takе cагe of to keеp it wise.
    I cаn't wait to read much more from you. This is really a great web site.
    My site :: free acne samples

    ReplyDelete