Top 10 Most Useful MS SQL System Stored Procedures

Last modified date:

System stored procedures are useful administrative tools. Below, you may find 10 of them which I consider as the most useful:

sp_help – info on objects in database, data types
sp_spaceused – displays space on the disk allocated to database and storage for each database objects including number of rows in the table
sp_who – returns info on currently connected users and their sessions
sp_lock – returns info on locked objects * procedure will be replaced in the future by systematic view Sys.dm_trans_locks
sp_configure – returns setting and enables changes to configuration for SQL instance
sp_tables – returns list of the tables which can be queried
sp_columns – list of the columns of database objects
sp_depends – Procedure receives argument of object and returns list of objects on which is mentioned object dependent and other way around – on which are other objects dependent (dependencies)

More on sql systematic procedures can be found on Microsoft web here

My name is Jan Zedníček and I work as a BI Developer at Kentico Software in Brno. Mostly you can see me there working in the office, but I also work partly as a freelancer. I have been working as a freelancer for many companies for more than 5 years, but Kentico is the matter of my heart. I used to work as a financial controller at companies like Aero Vodochody or Sberbank and I also used to be a bond program manager in Unicapital Investment group. When I am not at work, I like playing volleyball, chess, doing a workout in the gym and I enjoy tasting of best quality rums. I am trying to summarize all my knowledge on this website not to forget them (because of the rum effect, you know =) and to put them forward to anyone. Don´t worry about asking for help or writing some comments.

Category: SQL Tutorials Tags:

About Ing. Jan Zedníček - BI Developer, Finance controller

My name is Jan Zedníček and I work as a BI Developer at Kentico Software in Brno. Mostly you can see me there working in the office, but I also work partly as a freelancer. I have been working as a freelancer for many companies for more than 5 years, but Kentico is the matter of my heart. I used to work as a financial controller at companies like Aero Vodochody or Sberbank and I also used to be a bond program manager in Unicapital Investment group. When I am not at work, I like playing volleyball, chess, doing a workout in the gym and I enjoy tasting of best quality rums. I am trying to summarize all my knowledge on this website not to forget them (because of the rum effect, you know =) and to put them forward to anyone. Don´t worry about asking for help or writing some comments.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.