DatabaseJournal.com Staff

This script will generate disk init statements for all of your devices. For SQL Server 6.5 Author: Sharon Dooley Download Script: sp_lti_gen_disk_init.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 information on these […]

Requirements: SQL Server running on NT server. This is a stored procedure for sending generic messages to all users connected to SQL Server. It does not use email, and therefore does not require SMTP or Exchange server. It does use use the ‘NET SEND’ command on NT and utilizes the xp_cmdshell procedure to execute this […]

This stored procedure gives a quick and easy view of the space used / free in any database without suffering from the problems Enterprise Manager has in displaying the usages stats on large databases. The SP should be created in the master database, and called from the database you wish to interrogate. An option switch […]

Stored procedure to generate declare, open, fetch, close code for a user table, user view or system table. For SQL Server 6.5 Author: James E. Bothamley Download Script: sp_dclgen.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 […]

A stored procedure for generating details of the active SQL Server, scheduled tasks. The second stored procedure (optional)is used to call the main sp (using the scheduler?). The results are sent to a log file where the weekday number is used as a suffix for the file, to keep 7 days’ files before overwriting. Where […]

This procedure will run UPDATE STATISTICS against all user-defined tables on all databases. For SQL Server 6.5 Author: Amin, Vivek (FMAC Century City) Download Script: sp_update_statistics_all.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. […]

This script automatically synchronizes your NT logins with SQL Server logins. This eliminates the need to add or remove users in SQL Server – the maintenance only needs to be done in NT. As it is written, it only works for SQL Server 6.5 running Integrated Security. For SQL Server 6.5 Author: Rob Kraft Download […]

Good for: rebuilding indexes without using DBCC DBREINDEX; avoiding a bug (SP3) in which DBCC “forgets” OrigFillFactor and rebuilds huge, bloated indexes. What it does: for a given table, the proc finds all the (nonclustered) indexes, generates the appropriate statements to drop and rebuild the indexes (i.e., DROP/CREATE INDEX or ALTER TABLE DROP/ADD CONSTRAINT), and […]

Procedure to create a specified file on the SQLServer that contains all the indexes for a particular database. Used prior to dropping all the indexes on a database for a mass BCP in. Also shows a real example of using SQLOLE within TransactSQL. For SQL Server 6.5 Author: Keith Martin Download Script: sp_Script_Indexes.sql Disclaimer: We […]

This script will output the Approximate size (in MB) of each table in the database and finally will return the total size of the database. For SQL Server 6.5 Author: Amin, Vivek (FMAC Century City) Download Script: sp_totalsize.sql Disclaimer: We hope that the information on these script pages is valuable to you. Your use of […]

This script translates the SQLServer version number to the readable Servicepack id. It must be adapted, if new versions are released. For SQL Server 6.5 Author: Johannes Fischer Download Script: CheckSQLServerVersion.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, […]

sp_drop_index_all – Procedure to drop all indexes on a particular table. When you making Fast BCP works, you should drop all indexes on that table. There you can use this procedure instead of executing individual drop index statements of a table. For SQL Server 6.5 For Sybase SQL Server Author: Narasimhan Jayachandran Download Script: sp_drop_index_all.sql […]