| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 DB Synchronization Script | SQL Server 7.0 | Advanced /
Onder YILDIRIM | 5826 since
5/29/2002 4:38:33 AM |
By 4 Users
|
| |
This script is made up of several sp's, the main one being "sp_upg_GenerateSyncScripts". It creates scripts to synchronize one database schema with another. Especially useful when target database contains data. |
| |
| |
| |
|
 DBReindex | SQL Server 7.0, Other | Advanced /
NelsonR | 4633 since
3/20/2002 4:47:11 PM |
By 2 Users
|
| |
Script will reindex all of the table in a Database. Works with SQL Server 7.0 and SQL 2000. |
| |
| |
| |
 |
Defragmentation Script | SQL Server 2000, SQL Server 7.0 | Advanced /
Chong Long Choo | 4238 since
11/6/2005 9:01:00 AM | Unrated
|
| |
Most of the SQL Server administrators already familiar about DBCC DBREINDEX, DBCC INDEXDEFRAG and DBCC SHOWCONTIG. SQLDefrag just provide value-added feature to administrators, so that they can automate the database defragmentation or defrag database obje ...(description truncated) |
| |
| |
| |
|
Delete duplicates from a table | SQL Server 2000, SQL Server 7.0 | Beginner /
Bruce Donohue | 9854 since
12/19/2002 11:15:53 AM |
By 5 Users
2 Excellent Ratings
|
| |
The purpose of this script is to show three handy methods for handling duplicates in a table.
This is intended for those still new to the world of SQL.
|
| |
| |
| |
|
Deleting Sleeping Processes In SQL SERVER 2000 | SQL Server 2000 | Intermediate /
Kamal Kant Singh | 9626 since
11/9/2006 7:10:37 AM |
By 2 Users
|
| |
Sometimes We Develop Applications Where we Create a lot of DB Instances . Those Instrances remain sleeping on The Server DB and usually makes Hindrances in Using Connection Pooling Efficiently . |
| |
| |
| |
|
Demonstrate primary data files requirement for log backups in case of disaster.sql | SQL Server 7.0 | Beginner /
Umachandar | 3475 since
7/18/2000 8:42:35 AM | Unrated
|
| |
This script shows that a primary data file is required for a active log backup. Keep this in mind when recovering suspect databases, hardware failures etc. For more details, see a discussion on the same in the Windows 2000 Magazine SQL Server forum. |
| |
| |
| |
|
Deploy Stored Procedures with SP.vbs | SQL Server 2000 | Intermediate /
Igor Krupitsky | 7253 since
8/4/2006 11:39:55 AM |
By 1 Users
|
| |
This VBS script lets more easily you deploy stored procedures to a SQL Server. To use the script simply save the it to SP.vbs file, and drag and drop your SQL files on top of it. |
| |
| |
| |
|
 Do you have to review your backup strategy? | SQL Server 7.0 | Intermediate /
Found on the World Wide Web | 16587 since
7/13/2000 9:58:08 PM |
By 2 Users
2 Excellent Ratings
|
| |
Information in this article applies to: Microsoft SQL Server Version 7.0
Microsoft SQL Server makes many tasks easier. Especially organizing the backup and recovery process has become much easier, because no devices have to be created and the database ...(description truncated) |
| |
| |
| |
|
Document Generator | SQL Server 2000, SQL Server 7.0 | Advanced /
chandra sekhar | 4565 since
10/22/2003 12:17:04 PM |
By 2 Users
|
| |
generates document having the list of all the tables including their column names datatypes and with their extended properties also in the database
|
| |
| |
| |
|
drop a database using an on-demand task | SQL Server 6.5 and earlier | Intermediate /
Umachandar | 3040 since
8/11/2000 11:27:48 AM | Unrated
|
| |
This SP can be used to drop a database & device files by a SQL Executive job. |
| |
