Thursday, November 26, 2009

Get database file path and capacity

SQL Server 2000
SELECT * FROM sysfiles

SQL Server 2005 or later
SELECT * FROM sys.sysfiles

No comments:

Post a Comment

Oracle Query