Hi All,

Generally Sp_helptext can be used to check the definition of the objects like procedure,trigger,view,UDF,cursor. This is useful for the developer to check the code , for support professions to troubleshoot the issues.

Syntax for this is

Sp_helptext Object Name

Normally we need to write the sp_helptext for every object, now we can eliminate this by simple setting

Go to SSMS –tools-options—key board—query shortcuts and write sp_helptext for ctrl+0. You can take any short cut value

Select the any procedure and type control +0 , you can get the stored procedure definition

Please check and let us know if you have any concerns on this.

Thanks for viewing this.

Regards,

Chaitanya

Visit site: http://www.sqlblogging.com

Send an Email: sqlblogging