SQL Server 2008 R2 Database Process All Kill / Server üzerindeki tüm process'leri kapatmak

use master;

declare @DatabaseName varchar(50);

declare @Spid varchar(20);

declare @Command varchar(50);

set @DatabaseName = 'MyDatabase';

print 'This query''s SPID: ' + convert(varchar, @@spid);

-- Select all SPIDs except the SPID for this connection

declare SpidCursor cursor for

select spid from master.dbo.sysprocesses

where dbid = db_id(@DatabaseName)

and spid != @@spid

open SpidCursor

fetch next from SpidCursor into @spid

while @@fetch_status = 0

begin

    print 'Killing process: ' + rtrim(@spid);

    set @Command = 'kill ' + rtrim(@spid) + ';';

    print @Command;

    execute(@Command);

    fetch next from SpidCursor into @spid

end

close SpidCursor

deallocate SpidCursor

SQL Server 2008 Database isim değiştirme ( Rename)

EXEC sp_renamedb 'oldName', 'newName'

SQL Server 2008 R2 TempDb taşıma ( move)

TempDB nin nerede olduğunu sorgulayan T-SQL code

SELECT name, physical_name AS CurrentLocation

FROM sys.master_files

WHERE database_id = DB_ID(N'tempdb');

GO

-TempDB nin yerini değiştiren T-SQL code

USE master;

GO

ALTER DATABASE tempdb

MODIFY FILE (NAME = tempdev, FILENAME = 'D:\SQL\tempdb.mdf');

GO

ALTER DATABASE tempdb

MODIFY FILE (NAME = templog, FILENAME = 'D:\SQL\templog.ldf');

GO