| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Drop database AND FILES! | SQL Server 6.5 and earlier | Intermediate /
Umachandar | 8778 since
8/11/2000 11:28:59 AM | Unrated
|
| |
Drop a database & remove all the associated physical files--no more manual cleanup! |
| |
| |
| |
|
Drop Login | SQL Server 6.5 and earlier | Intermediate /
Umachandar | 3534 since
8/11/2000 11:28:21 AM | Unrated
|
| |
This SP can be used to drop a login from all databases |
| |
| |
| |
|
Drop User-defined Indexes | SQL Server 7.0, SQL Server 6.5 and earlier | Advanced /
Peter Wilkinson | 3339 since
10/1/2002 7:07:48 AM | Unrated
|
| |
This stored procedure will drop all nominated user-defined indexes from a database. |
| |
| |
| |
|
Drop/Add User in all Databases. | SQL Server 2000 | Intermediate /
Adonis Villanueva | 5688 since
1/14/2003 11:52:30 AM | Unrated
|
| |
This script will go through each Database in a Server and drops a specified user by using the sp_dropuser procedure. You can optionally use the sp_adduser procedure to add users instead or you can use whatever query you desire to execute on each and every ...(description truncated) |
| |
| |
| |
|
easy maintenance | SQL Server 2000 | Intermediate /
aguilar303 | 6496 since
8/28/2003 6:25:26 AM |
By 1 Users
|
| |
This script will reindex all tables on all databases on the server and then run consistency checks and backups for those databases. you can specify databases to be left out.
|
| |
| |
| |
|
elileiba | SQL Server 7.0 | Intermediate /
Eli Leiba | 4095 since
11/5/2001 3:18:12 PM |
By 2 Users
|
| |
Disable / Enable all referential constraints in the database,
this is a very handy sp that disable all fk (for maintance with no FK errors ) and
then ENABLE all FK again |
| |
| |
| |
|
Enumerate directories, files using NT DIR commands | SQL Server 7.0, SQL Server 6.5 and earlier | Beginner /
Umachandar | 4102 since
8/11/2000 12:15:34 PM |
By 1 Users
|
| |
This small script shows how to enumerate directories, files using NT DIR commands. This was my initial script & i moved this logic to a SP now. |
| |
| |
| |
|
Estimate Index usefullness | SQL Server 7.0 | Intermediate /
Eli Leiba | 5427 since
11/20/2001 7:51:15 AM |
By 4 Users
|
| |
decide if an index on a specified column is usefull or not |
| |
| |
| |
|
 Execute SQL on Multiple Tables/Columns | SQL Server 2000 | Advanced /
RAGHAVENDRA NARAYANA (PSI DATA SYSTEMS, BANGALORE) | 6164 since
12/8/2005 10:34:28 AM | Unrated
|
| |
The base idea of this article is to give leverage to run SQL Statement or Stored Procedure or User defined Function or set of SQL Statements on all/desired tables and on all/desired columns in the Database.
There requirements like you wanted to add/edi ...(description truncated) |
| |
| |
| |
|
Execute SQL on Multiple Tables/Columns–New feature in MS SQL SERVER 2000 | SQL Server 2000 | Advanced /
Raghavendra Narayana | 50997 since
9/11/2003 2:40:19 AM |
By 3 Users
3 Excellent Ratings
|
| |
The base idea of this article is to give leverage to run SQL Statement or Stored Procedure or User defined Function or set of SQL Statements on every/required tables and on every/required columns in the Database. There would have been a requirement like y ...(description truncated) |
| |
