SQL Server 7 Build List

A list of builds and versions for SQL Server 7.

Meta Data Services

Get DDL for any SQL 2000 table

a stored procedure returning a single varchar(8000) of the CREATE TABLE script for any table.It does everything calculated columns, rules,indexes,defaults,triggers,constraints...everything.

Read_Only Database

From the Real World: SQL Server 2000 SP4 Installation Failure

SQL 2000 SP4 failure on Cluster with error:Setup failed to perform required operations on the cluster nodes

Tables referenced by a stored proc (2000)

This should find all tables referenced by an sp. It uses syscomments and hence has a wrap 'issue'.

Find the port no Get Port SQL Server 2000

This Query is used to Find the port number or Get Port mumber SQL Server 2000 using T-SQL

Return Query Text Along With sp_who2 Using SQL 2000

This is a follow up to the article "Return Query Text Along With sp_who2 Using Dynamic Management Views".

Reverse engineering alias data types - Part 5

Continuing with his series on Alias Data Types in SQL Server 2000, Yakov Shmalfman brings us part 5, looking at indexes.

Script a Database Role

Script one or all roles in a database. Includes users, obect permissions and column permissions.