SQL scripts, coding and programming for database administrators

SQL Scripts & Samples

Test SQL Connectivity 02/01/2010
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/2010
This script imports the SQL Server error log into a table, so that it can be queried.

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

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

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

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

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

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

Services running on local MSSQL server 12/07/2009
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/2009
This udf_SuggestUserName function generates usernames based on date of birth, zipcode, username, firstname and lastname.

Importing flatfile data to MSSQL table 11/23/2009
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/2009
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/2009
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/2009
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/2009
This script moves databases to different physical locations.