Sign in
Microsoft.com
 
Script Center
 
 
 
Script Center > Gallery > Search
TechNet Script Center logo

Welcome to the TechNet Script Center Gallery!
Each contribution is licensed to you under a License Agreement by its owner, not Microsoft. Microsoft does not guarantee the contribution or purport to grant rights to it.
49 results in SQL Server 2005
Sort By: rss
Return SQL SERVER Logins Information (Community)
by Laerte Junior
This function returns information about SQL SERVER LOGINS
SQL Server 2005, SQL Server Databases, SQL Server 2008
(0)
11/23/2009
Windows PowerShell
Retrieve Waiter List Information (Microsoft)
by The Scripting Guys
Sample script that retrieves wait list information. The Waiter list contains resource waits waiting for the resource. Once a resource is available the corresponding session_id is
SQL Server 2005
(0)
8/10/2009
VBScript
Retrieve Waitstat Snapshots (Microsoft)
by The Scripting Guys
Sample stored procedure that retrieves waitstat snapshots for a workload in order to determine the top wait types during that workload. See inline comments for more details. This
SQL Server 2005
(0)
8/10/2009
VBScript
Report Blocker and Waiter SQL Statements (Microsoft)
by The Scripting Guys
Sample stored procedure that reports real time blocker and waiter SQL statements. This stored procedure, which requires Microsoft SQL Server 2005, lists real time blocks, includin
SQL Server 2005
(0)
8/10/2009
VBScript
Configure a Block Condition (Microsoft)
by The Scripting Guys
Sample script that holds locks in order to create a block condition. This script requires Microsoft SQL Server 2005.
SQL Server 2005
(0)
8/10/2009
VBScript
Handle a Block Condition (Microsoft)
by The Scripting Guys
Sample script for handling a block condition. A block situation is set up by running the script Create a Blocker Condition prior to running this procedure. This script requires Mi
SQL Server 2005
(0)
8/10/2009
VBScript
List Real-Time Blocker and Waiter Statements (Microsoft)
by The Scripting Guys
Sample script that lists real-time blocker and waiter SQL statements. This script requires Microsoft SQL Server 2005.
SQL Server 2005
(0)
8/10/2009
VBScript
List Lock and Serializable Information (Microsoft)
by The Scripting Guys
Sample script that lists lock and serializable information. The Transaction Isolation level is serializable. Note that, when xlocks are requested, key range xlocks are held until
SQL Server 2005
(0)
8/10/2009
VBScript
List Locks and Repeatable Reads (Microsoft)
by The Scripting Guys
Sample script that lists locks and repeatable reads. The Transaction Isolation level is set to repeatable read. Note that, when xlocks are requested, key xlocks are held until the
SQL Server 2005
(0)
8/10/2009
VBScript
List Locks and Reads (Microsoft)
by The Scripting Guys
Sample stored procedure that lists locks and reads. Range locks (serializable) disallows inserting in the range, while key locks (repeatable read) allow inserts (also known as pha
SQL Server 2005
(0)
8/10/2009
VBScript
1 - 10 of 49 Items < Prev 1 2 3 4 5  Next > All