[tarantino] r169 committed - bugfix: DropConnections.sql had hardcoded db name

0 views
Skip to first unread message

codesite...@google.com

unread,
Apr 22, 2011, 3:01:45 PM4/22/11
to tarantino...@googlegroups.com
Revision: 169
Author: aje...@gmail.com
Date: Fri Apr 22 12:01:09 2011
Log: bugfix: DropConnections.sql had hardcoded db name
http://code.google.com/p/tarantino/source/detail?r=169

Modified:

/trunk/src/Tarantino.DatabaseManager.Core/DatabaseManager/SqlFiles/DropConnections.sql

=======================================
---
/trunk/src/Tarantino.DatabaseManager.Core/DatabaseManager/SqlFiles/DropConnections.sql
Fri Apr 22 09:47:43 2011
+++
/trunk/src/Tarantino.DatabaseManager.Core/DatabaseManager/SqlFiles/DropConnections.sql
Fri Apr 22 12:01:09 2011
@@ -17,7 +17,7 @@
Master.dbo.SYSPROCESSES sp
inner join sys.dm_exec_sessions es on es.host_process_id =
sp.hostprocess
WHERE
- dbid IN (SELECT dbid FROM Master.dbo.SYSDATABASES WHERE name = 'ETT')
+ dbid IN (SELECT dbid FROM Master.dbo.SYSDATABASES WHERE name = '||
DatabaseName||')
AND spid <> @@SPID
AND es.is_user_process = 1

Reply all
Reply to author
Forward
0 new messages