DotnetDude DotnetDude - 9 months ago 16
SQL Question

Useful system stored procedures in SQL Server

I recently discovered that I could use the

to get a table definition and have been hooked onto it since then. Before my discovery, I had to open up the Object explorer in SQL Management studio, manually search for the table name, right click on the table and select Design. That was a lot of effort!

What other system stored procedures do you all use that you can't simply live without?


Alt + F1 is a good shortcut key for sp_help.

sp_helptext is another goodie for getting stored procedure text.