DotnetDude DotnetDude - 1 year ago 54
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?

Answer Source

Alt + F1 is a good shortcut key for sp_help.

sp_helptext is another goodie for getting stored procedure text.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download