SQLServerCentral.com Scripts tagged SQL Server 7

Get DDL for any SQL 2000 table

Tue, 28 Jul 2009 06:00:00 UT

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.

Table Index Store and Create

Fri, 17 Jul 2009 06:00:00 UT

Query to save all index metadata

Differential Backup Store Procedure for SQL Server 2000

Tue, 14 Jul 2009 06:00:00 UT

The Store Procedure can be use for generating Differential Backup datewise in SQL Server 2000.

Get alerts within 15 seconds of SQL Server issues
SQL Monitor checks performance data every 15 seconds, so you can fix issues before your users even notice them. Start monitoring with a free trial.

The Automated DBA: Batch Database File Grower - SQL2000 ReportOnly Ver

Fri, 19 Jun 2009 06:00:00 UT

Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.

The Automated DBA: Batch Database File Grower - SQL 2000 Version

Thu, 25 Jun 2009 06:00:00 UT

Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.

Yet Another Deleting Duplicate Records (in-place)

Thu, 15 Jan 2009 07:00:00 UT

Here is another "deleting duplicate records" script, this time in-place, using a uniqueidentifier column.

Tables referenced by a stored proc (2000)

Tue, 30 Dec 2008 07:00:00 UT

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

Generate a random password

Wed, 15 May 2013 06:00:00 UT

If you ever need a quick way to generate random passwords, this is a pretty useful way to do so.

Permission scripting over all databases

Wed, 10 Sep 2008 07:28:09 UT

Scripts permissions/roles for db user across all databases.

Find the port no Get Port SQL Server 2000

Sat, 09 Aug 2008 19:34:48 UT

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

Delimited String Parsing Functions - TwoCol set

Mon, 03 Nov 2008 07:00:00 UT

Feed it two delimited strings of horizontal data and it returns it back as a vertical table with the two column data in the same synchronized position order.

Delimited String Parsing Functions - Big Set

Wed, 06 Aug 2008 03:03:20 UT

Feed it large strings of delimited horizontal data and it returns it back as a vertical table.

Delimited String Parsing Functions - Basic Set

Mon, 20 Oct 2008 06:00:00 UT

Feed it delimited horizontal data and it returns it back as a vertical table.

Counter Table (table of numbers) Setter-Upper for SQL Server 2000

Wed, 06 Aug 2008 02:50:45 UT

Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 620, 384400, and 238328000 numbers.

Logins created in the last X Days

Fri, 23 Dec 2011 07:00:00 UT

These scripts give you the list of logins created in the Last X Days for SQL Server 2000 or 2005.

Monitor Any Linked Server From SQL 2000

Fri, 11 Jul 2008 06:00:00 UT

Best way to monitor Excel, Access, SQL Linked Servers from SQL 2000

usp_SecurCreation - SQL 2k

Thu, 26 Jun 2008 06:00:00 UT

Creates statements for securables creation.

Proc to Rename a file

Fri, 28 Oct 2011 06:00:00 UT

A simple way to rename a file from within a T-SQL Script, primarily designed to add a date-time stamp. Works in 2000 and 2005.

Show content differences between two tables/views

Fri, 13 Jun 2008 06:00:00 UT

A stored procedure that generates sql to determine the difference for each record and field.

Row count and space used for all tables in database (update)

Wed, 25 May 2011 06:00:00 UT

This procedure works like the sp_spaceused procedure but this one shows statistics for all tables in the selected database or for all databases (excluding tempdb and model).

Import/Export SQL Server 2000 Enterprise Manager Registered Servers

Thu, 08 May 2008 06:00:00 UT

Exports and imports SQL Server 2000 Enterprise Manager groups and server registrations using Powershell.

Available bytes for row expansion (adding columns) in a table

Thu, 03 Apr 2008 06:00:00 UT

This scalar function accepts a table name and returns the number of bytes left out of the 8060 bytes available for adding new columns.

Comprehensive Backup Script

Thu, 22 Dec 2011 07:00:00 UT

These scripts were generated to standardize our SQL backup environments, and to remove backups from Maintenance Plans.

Script a Database Role

Thu, 08 Sep 2011 06:00:00 UT

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

Generate SQL Scripts from Database

Fri, 16 Dec 2011 07:00:00 UT

Simulate EM's Generate SQL Scripts with DMO and VBS

Restore database with all necessary files

Wed, 13 Jul 2011 06:00:00 UT

It creates the script for restoring your database with all the backups (full, differential and transaction log) needed.

Set standard database options

Mon, 19 Sep 2011 06:00:00 UT

Ensure all your databases have standardised options by running this script weekly.

Backup Stored Proc

Fri, 09 Sep 2011 06:00:00 UT

Script to backup 2000/2005 databases.

Database source control in just 5 minutes
It takes just 5 minutes to connect your SQL databases to source control. Got 5 minutes to spare? Get started now.

Check Availability Window - SQL2k

Fri, 18 Jan 2008 07:00:00 UT

This script allows you to check the several availability windows for the current day.

Check Instance Info

Thu, 15 Dec 2011 07:00:00 UT

Named or default instance, this will check info like Virtual Server Name, Cluster Name , Current owner, Preferred Owner? and? Status? (if clustered) and IP/Port for the current instance.