Script Library

Another link to the  DDL scripts from the admin db in case you didn't get here from the main page:

The admin Database for SQL Server 2000 as scripted by the DDL Archive Utility

Scripts that are also posted in the sswug.org script library (but the version here may be more recent)

current activity quick and clean
list tables on server with no data
create linked servers with standard config
force users out of a database
identify and track tables with no clustered indexes
automated block monitoring and tracking
number of objects on server monitor of tracking
index (fragmentation) maintenance
identify largest tables on the server
automated log disk space management
find user objects where they don't belong
show all fixed database role members
move log files to a different drive
table function to get Agent job status
add identity primary keys to legacy tables
meaningful Agent job notification
change the SID of a login without loss of security settings
sp_monitor history and historical performance report
Free Space Monitoring Tool stored procedures and job
Run a job from all existing SQL Agent Alerts
Track Procedures In Use on a SQL Server
Heavy Duty LiteSpeed Log Shipping
Index (fragmentation) Maintenance for Log Shipping
YukonJack - Try-Catch test script
Local Partition Demo - Saturday Night Live
Local Partition Demo - Middle of The Road
Local Partition Demo - Life of the Party
baseline and trends using sysperfinfo
db file performance baseline and trends using --fn_virtualfilestats
can SQL Agent job be safely started
script logins for migration
 

Utility SQL Scripts

AlterTableConversionFrom PULL.sql
Average Daily reads.sql
disable ALL backup jobs.sql
DROP a domain login.sql
find all nullable text and image cols on server.sql
find all text and image cols in current db.sql
find cursors.sql
find trailing white space.sql
find user objects with public permissions.sql
findstr in project folders.sql
indexesByFileGroup.sql
indexesbytype.sql
InsertUpdateDeletePermsiisnsByDBbyTable.sql
lodctr command line.sql
make_Add_RID_PKEY_script.sql
map a login to a new SID keeping user perms.sql
members in all fixed db roles.sql
move log files to diff drive.sql pkgwithGV.sql
proc_traceZeus.sql
ProductionStorageSummary.sql
recompile aggregation from trace table.sql
roles and members 2.sql
roles and members.sql
roles members users permissions script.sql
roles members users permissions.sql
run a query on all linked servers.sql
script detatch attach ALL.sql
script restore all dbs from same path.sql
showcontig into a table.sql
showcontigByIndex.sql
shrinkalldbs10pct.sql
sizes from sysperfinfo.sql
space used into a table.sql
SpaceUsedHistoryQuery.sql
sp_calcspace7.sql
sp_corruptdb.sql
SQL 2000 Trace Events lookup table.sql
sqlstripetest.sql
StillSQL65Collation.sql
sysperfinfo log info.sql
sysperfinfo queries.sql
tables not replicated.sql
tables using most space in a DB.sql
trace from ZEUS.sql
trace table list queries.sql
trace to identify all sa logins.sql
traceApollo.sql
traceDBForReplay.sql
traceServerForReplay.sql
Transaction and IO metrics.sql
VersionOfAnyFile.sql
virtualfilestats performance.sql
 

ActiveX Scripts

- taken from DTS packages but most will also work with the Windows Scripting Host provided the expected DTS global variables and constants are modified to be script parameters or removed as necessary.

Copy procedures from Database A to Database B AxtiveX Script Task
Free Space Monitoring Tool ActiveX Script Task
SQLDMO Script DDL AcitveX Script Task
Check in Scripts Generated by SQLDMO Task into SourceSafe ActiveX Script Task

(Note that these backup scripts here generally support both native and SQL LiteSpeed backups)
Backup a Server
Backup Primary Restore Warm spare (SQLLitespeed or native) ActiveX Script task - a monolithic DTS based backup/restore utility
Backup Driver - the driver for a flexible and highly customizable metadata driven DTS backup solution

    Examples of called packages used by Backup Driver

Archive a Backup Device - In this backup archive strategy, the file system backups to tape does the delete of a file once it is moved to tape. The database backup processing simply renames with a numeric file extension any existing backup file if it is found on disk.
• Backup a Database
• Differential Backup of a Database
• Log Backup of a Database
• Restore a Database
• Restore of a Database With Move
• Log Restore of a Database

    These are jobs built with the DTS Package Builder UI rather than ActiveX DTS tasks
    Presented here as DTS Packages "Save(d) As..." VB Scripts.

• Expunge Users from a Database - not an ActiveX script, but the .bas of a DTS package that uses a Dynamic Properties Task and a SQL Task to call the procedure admin.dbo.ExpungeUsers. Very useful when restoring a database.
• Backup History Delete Archive - not an ActiveX script, but the .bas of a DTS package that uses a Dynamic Properties Task and a SQL Task to call the system procedure msdb.dbo.sp_delete_backuphistory.

ListSQLServices.vbs - Find the system process id for each SQL Server and SQL Agent running on the local host using WMI. Useful to match up with task manager information when you have a performance problem on a multi-instanced machine.