SELECT NAME ,
SIZE * 8.0 / 1024 'Current Size In MB'
FROM tempdb.sys.database_files;
SELECT NAME ,
SIZE * 8.0 / 1024 'Initial Size in MB'
FROM master.sys.sysaltfiles
WHERE dbid = 2;
SIZE * 8.0 / 1024 'Current Size In MB'
FROM tempdb.sys.database_files;
SELECT NAME ,
SIZE * 8.0 / 1024 'Initial Size in MB'
FROM master.sys.sysaltfiles
WHERE dbid = 2;
No comments:
Post a Comment