Skip to content

Instantly share code, notes, and snippets.

@agross

agross/gist:181495

Created September 5, 2009 19:38
Show Gist options
  • Save agross/181495 to your computer and use it in GitHub Desktop.
Save agross/181495 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.diff
diff --git a/src/Tarantino.Core/DatabaseManager/SqlFiles/DropConnections.sql b/src/Tarantino.Core/DatabaseManager/SqlFiles/DropConnections.sql
index 46c7f7f..96fd0e0 100644
--- a/src/Tarantino.Core/DatabaseManager/SqlFiles/DropConnections.sql
+++ b/src/Tarantino.Core/DatabaseManager/SqlFiles/DropConnections.sql
@@ -15,6 +15,7 @@ SELECT
spid
FROM Master.dbo.SYSPROCESSES
WHERE dbid IN (SELECT dbid FROM Master.dbo.SYSDATABASES WHERE name = '||DatabaseName||')
+ AND hostprocess <> ''
AND spid <> @@SPID
SET @x = (SELECT MIN(nid) FROM #LIVE_SPIDS)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment