Fahri Dönmez ~ Yazılım Uzmanı

Not Defterim: Programlama (Abap, Troia, c#, sql) ve Sistem (Windows, Linux, Android)

Yayın tarihi 10/01/2014 Fahri Dönmez

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)

Yayın tarihi 17/09/2013 Fahri Dönmez

Cevapla

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)