DECLARE @User VARCHAR(8000) SELECT @user=COALESCE(@user,'')+'Kill '+CAST(spid AS VARCHAR(10))+ '; ' FROM sys.sysprocesses WHERE DBID=DB_ID('EF_GR') EXEC(@user)
I have been in IT sector for 10 years. As professionals know everything is not going in rules. I will share my experiences and small tips&tricks about Microsoft Server Family , Cisco Devices , HP and IBM servers and storages on this site.
Egemen TANIRER (Computer Engineer)
No comments:
Post a Comment