| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Objects blocked | SQL Server 7.0 | Intermediate /
Mario Estrada | 4927 since
4/30/2001 11:42:48 AM |
By 2 Users
|
| |
With this script you can find wich objects are blocked by a given SPID |
| |
| |
| |
|
Orphan Process Details using DBCC PSS.sql | SQL Server 7.0 | Beginner /
Umachandar | 5810 since
7/23/2000 2:10:12 PM | Unrated
|
| |
This script shows how to get details about an orphan process in SQL70. |
| |
| |
| |
|
Report all DataBases Options | SQL Server 7.0 | Advanced /
Eli Leiba | 5263 since
11/18/2001 10:18:01 AM |
By 1 Users
|
| |
To get a report of all DataBase options using a bit mask on the status columns in sysdatabases |
| |
| |
| |
|
sp_blockinglocks.sql | SQL Server 7.0 | Advanced /
Umachandar | 6976 since
7/23/2000 2:13:19 PM | Unrated
|
| |
A SP to view the blocking locks in a database. Taken from Kalen's InsideSQLServer website. |
| |
| |
| |
|
sp_lock_ex.SQL | SQL Server 7.0 | Advanced /
Umachandar | 4800 since
7/23/2000 2:19:15 PM | Unrated
|
| |
This SP can be used to view locking information in the system. Allows various searching capabilities that is not available in EM & this one doesn't use temporary tables. (Setup procedure is in http://www.planet-source-code.com/vb/scripts/ShowCode.asp?lngW ...(description truncated) |
| |
| |
| |
|
SP_SIO.SQL | SQL Server 7.0 | Intermediate /
Umachandar | 3134 since
7/23/2000 2:11:37 PM | Unrated
|
| |
This SP can be used to search for a string in the last input command sent to SQL Server from a user connection. The search can be done based on SPIDs or username. |
| |
| |
| |
|
sp_tisize.sql | SQL Server 7.0 | Advanced /
Umachandar | 3381 since
7/23/2000 2:18:07 PM | Unrated
|
| |
This SP provides a detailed report on tables & indexes similar to the EM Tables & Indexes page. Provides filtering capabilities, eliminating DBCC output messages etc. Demonstrates other techniques to manipulate files from SQL Server. |
| |
| |
| |
|
SP_TLIST.SQL | SQL Server 7.0 | Intermediate /
Umachandar | 2923 since
7/23/2000 2:16:22 PM | Unrated
|
| |
This SP can be used to list the i/o buffer of a specific SPID. The SPIDs can be specified as a list or the username can be specified. |
| |
| |
| |
|
sp_who_ex.SQL | SQL Server 7.0 | Advanced /
Umachandar | 3592 since
7/23/2000 2:16:56 PM |
By 1 Users
|
| |
This SP allows powerful search capabilities & ordering features for the processes using SQL Server. This does not use temporary tables & hence works better than the EM current activity window. |
| |
| |
| |
|
table stats | SQL Server 2000 | Advanced /
theCoiMan | 4620 since
1/3/2003 12:03:33 AM |
By 1 Users
|
| |
I had to figure out why a clients database increase from 3 gigs to 12 gigs in one month. So I wrote this stored procedure to find out what table was taking up all the space in the db. Hope it helps you out. |
| |
