Kills connections in database if database exists
(conn, db)
| 92 | |
| 93 | |
| 94 | def KillConnections(conn, db): |
| 95 | """ |
| 96 | Kills connections in database if database exists |
| 97 | """ |
| 98 | |
| 99 | s = 'SET NOCOUNT ON DECLARE @kill varchar(8000) = ' + chr(39) + chr(39) + ';' |
| 100 | s += ' SELECT @kill = @kill + ' + chr(39) + 'kill ' + chr(39) + ' + CONVERT(varchar(5), spid) + ' + chr(39) + ';' + chr(39) |
| 101 | s += ' FROM master..sysprocesses WHERE dbid = db_id(' + chr(39) + db + chr(39) + ')' |
| 102 | s += ' select @kill; EXEC(@kill);' |
| 103 | |
| 104 | rows, fnames = [], [] |
| 105 | try: |
| 106 | rows, fnames = SqlExecute(conn, s) |
| 107 | except Exception as inst: |
| 108 | print('Error killing connections: ', inst) |
| 109 | return rows |
| 110 | |
| 111 | def SyncLogins(conn, db): |
| 112 | s = ''' |
no test coverage detected