title: Useful system stored procedures in SQL Server
body: <p>I recently discovered that I could use the <code>sp_help</code> 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!</p>
  
  <p>What other system stored procedures do you all use that you can't simply live without?</p>