DECLARE @sql nvarchar(4000)
SET @sql= ''
SELECT @sql = @sql + ' kill ' + CAST(spid AS VARCHAR) + CHAR(13)
FROM master.sys.sysprocesses WHERE dbid = db_id( 'GX_VTS_ManagementCenter_4.5')
EXEC(@sql)
EXEC sp_executesql @sql
DECLARE @sql nvarchar(4000)
SET @sql= ''
SELECT @sql = @sql + ' kill ' + CAST(spid AS VARCHAR) + CHAR(13)
FROM master.sys.sysprocesses WHERE dbid = db_id( 'GX_VTS_ManagementCenter_4.5')
EXEC(@sql)
EXEC sp_executesql @sql