DatabaseJournal.com Staff

The attached procedure I received from SQL Admin. class. It will produce the order/size of the database segments. For SQL Server 6.5 Author: John Driggers Download Script: Dev_frag.sql Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in these pages, however, is at your […]

The current identity value could be invalid – more after abnormal shutdowns. This SP checks all the tables containing an identity column. You can schedule this SP, or make it run at startup. For SQL Server 6.5 Author: German S. Arduino Download Script: sp_checkidents.sql Disclaimer: We hope that the information on these script pages is […]

We needed a hands off method to refresh all of the data periodically. So, I created a script. It’s relatively clean, but I didn’t go for the style points. You’ll find good use of dynamic SQL and also nested cursors in this one. (If anyone can come up with a way to get rid of […]

sp_Backup permits to automate the task of Backup of the Databases taking a Dump of all the existing bases on a device of Dump. The SP it should be to generate in Master and it can be put as Scheduled Task. Because it reads the databases from sysdatabases, avoids to update the sp when databases […]

This script lists tablename, number of rows, data size, index size and total reserved size for (by default) all tables in the database, with largest tables first. For SQL Server 6.5 Author: Vince Iacoboni Download Script: sp_ABTableSize.sql Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the […]

This script provides tablename, indexname, cluster, unique, and PK info, and the first eight columns of the index for (by default) all tables or all tables matching a tablename pattern. For SQL Server 6.5 Author: Vince Iacoboni Download Script: sp_ABIndexInfo.sql Disclaimer: We hope that the information on these script pages is valuable to you. Your […]

Reverse engineer SQL Executive scheduled tasks so that they can be backed up or transferred to another server. For SQL Server 6.5 Author: Vince Iacoboni Download Script: sp_ABhelp_revtasks.sql Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in these pages, however, is at your […]

This procedure will reverse-engineer the needed DISK INIT statements for use in the case of a catastraphic data loss. Should be used along with sp_help_revdatabase (from MS) and database dumps to ensure recreatability of SQL backups. For SQL Server 6.5 Author: Vince Iacoboni Download Script: sp_ABhelp_revdevice.sql Disclaimer: We hope that the information on these script […]

A procedure to estimate the disk space requirements of a table and its associated indexes. For SQL Server 6.5 Author: Gail Singh Download Script: ESTSPACE.SQL Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in these pages, however, is at your sole risk. All […]

To force logout of all users at a given time, set this stored procedure to run as a scheduled task at whatever time you want everyone out. Then exec the sp_dboption with ‘false’ when you’re ready to let them on again. For SQL Server 6.5 Author: Marty Parten Download Script: killusers.sql Disclaimer: We hope that […]

Takes a passed database name and builds a SQL script that will drop the database, drop the devices, rename the device files, then create new devices, and finally create a new database with the same options and usage fragments as when this procedure was run. This procedure is recommended to be run whenever a full […]