SQL scripts, coding and programming for database administrators
Use this stored procedure to quickly capture all login information when needed, especially for security audit situations.
Practice INSERT into.
Piece of code to search all stored procedures in all databases for keyword.
Helps DBA to find out quickly which database takes a lot of space and which file could be shrunk. Very useful when output is sorted by Drive Letter when "Out of space" occurs.
Want to use this function in PHP/MySQL but new to PHP/MySQL. It works by taking the select member code description and the last assigned number and format as CON-00001 once the focus in lost after selecting the member description from dropdown list on the form.
Used when checking to see if the registered user is already in the database.
Creating Excel using TSQ-L.
Disk Space Used for all databases.
This script looks for all failed jobs in the last day.
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 file. XDL file is the deadloack graph that can be opened in SSMS.
Uploading a flat file into an Oracle database.
This script tests connectivity to SQL Server box from a client machine when there is no SQL Client.
This script imports the SQL Server error log into a table, so that it can be queried.
This script displays CPU information.
Add Your Script
SQL Scripts & Samples Archives
This script finds the number of process instances running on a server.