SQL scripts, coding and programming for database administrators

SQL Scripts & Samples

Test SQL Connectivity 02/01
This script tests connectivity to SQL Server box from a client machine when there is no SQL Client.

Import the SQL Server Error Log into a Table 01/25
This script imports the SQL Server error log into a table, so that it can be queried.

Display CPU Information 01/19
This script displays CPU information.

Check Windows Process 01/11
This script finds the number of process instances running on a server.

Reboot Machines 01/04
This batch file will reboot machines.

Unix script for performing repetitive jobs 12/28
This shell script executes a while loop for performing the required job.

Get Last Day Of Month 12/21
This script will get the last day of the month.

DEFAULT column values 12/14
To avoid ARC_Triggers creation, you can use DEFAULT column values.

Services running on local MSSQL server 12/07
The procedure will list code, name and current state of each service that is installed on the machine where SQLSERVER2000 is running.

Generate UserNames 11/30
This udf_SuggestUserName function generates usernames based on date of birth, zipcode, username, firstname and lastname.

Importing flatfile data to MSSQL table 11/23
This script is used to read the data from a flat file and then populate it into the database table.

Find SQL Server Authentication Mode 11/16
This script can be used on both SQL 2000 and SQL 2005 to find the Authentication mode set for the sql instance.

Stored Procedure NetSend 11/09
This stored procedure can be used by database administrators to inform users, prior to breaking the user's connection to the database.

Track Table Fragmentation 11/02
A diagnostic table and stored procedure to track the fragmentation of large tables within databases. The user passes the database name and the table name as parameters to the SP. The SP can be set up to run as a scheduled job every few hours to produce a historical trend of fragmentation.

Detach & Attach User Databases 10/26
This script moves databases to different physical locations.