|
SQL scripts, coding and programming for database administrators
02/01
This script tests connectivity to SQL Server box from a client machine when there is no SQL Client.
01/25
This script imports the SQL Server error log into a table, so that it can be queried.
01/19
This script displays CPU information.
01/11
This script finds the number of process instances running on a server.
01/04
This batch file will reboot machines.
12/28
This shell script executes a while loop for performing the required job.
12/21
This script will get the last day of the month.
12/14
To avoid ARC_Triggers creation, you
can use DEFAULT column values.
12/07
The procedure will list code, name and current state of each service that is installed on the machine where SQLSERVER2000 is running.
11/30
This udf_SuggestUserName function generates usernames based on date of birth, zipcode, username, firstname and lastname.
11/23
This script is used to read the data from a flat file and then populate it into the database table.
11/16
This script can be used on both SQL 2000 and SQL 2005 to find the Authentication mode set for the sql instance.
11/09
This stored procedure can be used by database administrators to inform users, prior to breaking the user's connection to the database.
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.
10/26
This script moves databases to different physical locations.
Add Your Script
SQL Scripts & Samples Archives
|
