SQL scripts, coding and programming for database administrators
02/01/2010
This script tests connectivity to SQL Server box from a client machine when there is no SQL Client.
01/25/2010
This script imports the SQL Server error log into a table, so that it can be queried.
01/19/2010
This script displays CPU information.
01/11/2010
This script finds the number of process instances running on a server.
01/04/2010
This batch file will reboot machines.
12/28/2009
This shell script executes a while loop for performing the required job.
12/21/2009
This script will get the last day of the month.
12/14/2009
To avoid ARC_Triggers creation, you
can use DEFAULT column values.
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.
11/30/2009
This udf_SuggestUserName function generates usernames based on date of birth, zipcode, username, firstname and lastname.
11/23/2009
This script is used to read the data from a flat file and then populate it into the database table.
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.
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.
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.
10/26/2009
This script moves databases to different physical locations.
Add Your Script
SQL Scripts & Samples Archives
|
» 
