Write for Us
sp_MSgettools_path
This stored procedure returns the path to the SQL Server 2000 tools and utilities.
Syntax
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.
GO
DECLARE @install_path NVARCHAR(260)
EXEC sp_MSgettools_path @install_path OUTPUT
SELECT @install_path
Here is the result set from my machine:
C:\Program Files\Microsoft SQL Server\80\Tools
sp_MScheck_uid_owns_anything
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
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'