select * from sys.dm_db_task_space_usage
where internal_objects_alloc_page_count <> 0
kill 49
Msg 6107, Level 14, State 1, Line 1
Only user processes can be killed.
How do I kill the session ID?
I have restarted the server, but it did not kill the process.
Cannot use the bellow statement on System databases
USE master;
go
ALTER DATABASE [FooData] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
go
ALTER DATABASE FooData SET MULTI_USER;
go