Every Question..What does it mean? Why is this? How it works?
Microsoft .Net (pronounced dot (.) net) may be a package element that runs on the Windows software package.
.Net provides tools and libraries that change developers to form Windows package a lot of quicker and easier.
Microsoft describes it as:".Net is that the Microsoft internet Service strategy to attach data, people,
system and devices through software".I'm Choulla Naresh..!
use master
DECLARE @sessionId INT;
DECLARE kill_cursor CURSOR FOR
SELECT session_id
FROM sys.dm_exec_sessions
WHERE database_id=DB_ID('DBName');
OPEN kill_cursor;
FETCH NEXT FROM kill_cursor INTO @sessionId;
WHILE @@FETCH_STATUS=0
BEGIN
PRINT 'Killing session:'+CAST(@sessionId AS VARCHAR(10));
EXEC('KILL '+@sessionId);
FETCH NEXT FROM kill_cursor INTO @sessionId;
END
CLOSE kill_cursor;
DEALLOCATE kill_cursor;