Some useful System Stored Procedures for Developers/DBAs: 1. sphelp( keyboard shortcut Alt + F1) - Reports information about a database object, a user-defined data type, or a data type. 2. sphelpdb - Reports information about a specified database or all databases. 3. sphelptext - Displays the definition of a user-defined rule, default, unencrypted Transact-SQL stored procedure, user-defined Transact-SQL function, trigger, computed column, CHECK constraint, view, or system object such as a system stored procedure. 4. sphelpfile - Returns the physical names and attributes of files associated with the current database. Use this stored procedure to determine the names of files to attach to or detach from the server. 5. sp_columns - Returns column information for the specified tables or views that can be queried in the current environment.

Published under: SQL Server Tips ·  ·  ·  ·