Viewing 2 posts - 1 through 2 (of 2 total)
... or rather than SELECT * FROM table WHERE 1 = 2;
SELECT TOP 0 * FROM table;
December 10, 2020 at 6:42 pm
#3819071
karthik.catchme (4/9/2013)
Please let me know how to get the initial size of the database file using T-SQL.
sys.master_files, sys.database_files, sysfiles, sysaltfiles --> gives only the current size and not the...
October 6, 2015 at 4:41 pm
#1831880