SELECT SERVERPROPERTY('productversion') as productversion, SERVERPROPERTY ('productlevel') as productlevel, SERVERPROPERTY ('edition') as edition
productversion productlevel edition 10.0.2531.0 SP1 Enterprise Edition (64-bit)
SELECT SERVERPROPERTY('productversion') as productversion, SERVERPROPERTY ('productlevel') as productlevel, SERVERPROPERTY ('edition') as edition
productversion productlevel edition 10.0.2531.0 SP1 Enterprise Edition (64-bit)
SELECT name, size FROM sys.master_files WHERE database_id = DB_ID(N'tempdb');
name size ------------ ----------- tempdev 476304 templog 224
(2 row(s) affected)
DBCC SHRINKFILE(tempdev, 5)