usp_KillUsers2

This script expands on the usp_KillUsers script posted by Brian Knight, by adding the text of the process that is being killed and will even kill users who are accessing the database from with in a process of another database. Does not contain the NET SEND option though.

What does this do?

SELECT getdate()
WHERE getdate() > getdate()-1
OR getdate()-1...

Given type-compatible relations T1 and T2, which of...

Given type-compatible relations T1, T2, and T3, which...

Search for text in procedures (no cursors) UPDATE

This is an update to the Search for text in procedures (no cursors) function (excellent script), which lists all of the objects (searching in syscomments, so it excludes tables). I have added a 2nd column to the output of the object type.

In the following SQL query:


SELECT a, b, c
FROM...

SQL Server 2005 adds recursive queries as a...

CREATE TABLE #foo (col varchar(100))
GO
INSERT INTO #foo VALUES...

Given this:

DECLARE @BeginDate smalldatetime
DECLARE @EndDate smalldatetime
SET @BeginDate = '01/01/2005'
SET...

In SQL Server 2000, you have the following:

CREATE...