Kill Process

Is there any T-SQL language command to kill all process in one database?
Hi
You have to loop thru all processes and generate KILL command
"Cenk FIRAT" <CenkFIRAT@.discussions.microsoft.com> wrote in message
news:6FEB320A-307A-4B2B-926A-28EC1162BD2D@.microsoft.com...
> Is there any T-SQL language command to kill all process in one database?
|||Try:
ALTER DATABASE MyDatabase
SET SINGLE_USER WITH ROLLBACK IMMEDIATE
ALTER DATABASE MyDatabase
SET MULTI_USER
Hope this helps.
Dan Guzman
SQL Server MVP
"Cenk FIRAT" <CenkFIRAT@.discussions.microsoft.com> wrote in message
news:6FEB320A-307A-4B2B-926A-28EC1162BD2D@.microsoft.com...
> Is there any T-SQL language command to kill all process in one database?