Shortcuts, SQL Server

View contents of a Stored Procedure (quickly)

I am currently working on a SQL Server 2005 database that has over 500 stored procedures on it. And finding them on the object explorer has been tedious if i just need to view its contents. So i prefer typing in ‘SP_HELPTEXT <procname>’ to view the contents of the procedure. But SQL Server management studio provides an easier way to accomplish this.. You can assign a quick kepboard shortcut to access the contents of the procedure. Just go to Tools -> Options -> Keyboard and type in SP_HELPTEXT for a key of your choice. Now just select the procedure name and hit the shortcut key ..

image

Advertisements