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




Continues…

Pages: 1 2 3 4 5




Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |