SQL Server 2000 Undocumented Stored Procedures
This stored procedure returns the path to the SQL Server 2000 tools and utilities.
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.
DECLARE @install_path NVARCHAR(260)
EXEC sp_MSgettools_path @install_path OUTPUT
Here is the result set from my machine:
C:Program FilesMicrosoft SQL Server80Tools
This stored procedure returns the list of the objects, owned by the specified user.
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.
EXEC sp_MScheck_uid_owns_anything 1
This stored procedure returns the complete column description, including the length, type, name, and so on.
|sp_columns_rowset table_name [, table_schema ] [, column_name]|
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:
EXEC sp_columns_rowset ‘authors’