Home Page Logo
Copyright 2020 © QuinStreet Inc. All Rights Reserved
SQL Scripts & Samples
Find Failed Jobs in 24 Hours
This script looks for all failed jobs in the last day.
Dead Lock Graph
This script will create the base table, stored procedures, set up alert, Job for the dead lock. The output will send both xml and xdl …
Uploading a CSV File into an Oracle Database
Uploading a flat file into an Oracle database.
Test SQL Connectivity
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
This script imports the SQL Server error log into a table, so that it can be queried.
Display CPU Information
This script displays CPU information.
Check Windows Process
This script finds the number of process instances running on a server.
This batch file will reboot machines.
Unix script for performing repetitive jobs
This shell script executes a while loop for performing the required job.
Get Last Day Of Month
This script will get the last day of the month.
DEFAULT column values
To avoid ARC_Triggers creation, you can use DEFAULT column values.
Services running on local MSSQL server
The procedure will list code, name and current state of each service that is installed on the machine where SQLSERVER2000 is running.
This udf_SuggestUserName function generates usernames based on date of birth, zipcode, username, firstname and lastname.
Importing flatfile data to MSSQL table
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
This script can be used on both SQL 2000 and SQL 2005 to find the Authentication mode set for the sql instance.
Acceptable Use Policy
Terms of Service
California - Do Not Sell My Info