SQL Server 2000 Undocumented Stored Procedures

sp_MSgettools_path

This stored procedure returns the path to the SQL Server 2000 tools and utilities.

Syntax

sp_MSgettools_path install_path

where

install_path - is the installation path. It’s output parameter. install_path is nvarchar(260).

This is the example to get the path to the SQL Server 2000 tools and utilities.

USE master GO DECLARE @install_path NVARCHAR(260) EXEC sp_MSgettools_path @install_path OUTPUT SELECT @install_path GO

Here is the result set from my machine:

———————————————————— C:Program FilesMicrosoft SQL Server80Tools

sp_MScheck_uid_owns_anything

This stored procedure returns the list of the objects, owned by the specified user.

Syntax

sp_MScheck_uid_owns_anything uid

where

uid – is the User ID, unique in this database. uid is smallint.

This is the example to get the list of the objects, owned by the database owner 1 in the pubs database.

USE pubs GO EXEC sp_MScheck_uid_owns_anything 1 GO

sp_columns_rowset


This stored procedure returns the complete column description, including the length, type, name, and so on.

Syntax

sp_columns_rowset table_name [, table_schema ] [, column_name]

where

table_name - is the table name. table_name is sysname.

table_schema – is the table schema. table_schema is sysname, with a default of NULL.

column_name - is the column name. column_name is sysname, with a default of NULL.

This is the example:

USE pubs GO EXEC sp_columns_rowset ‘authors’ GO