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 |