Posted by Erland Sommarskog on 12/13/06 22:50

caseahr (caseahr@gmail.com) writes:
> When you create data files and filegroups, you specify a size. My
> question is -- how do you know how full they are? Is there a stored
> procedure for that?

It should be possible to find by querying a couple fo system tables.
But before I go ahead, I need to know which version of SQL Server you
are using, because the solution for SQL 2005 is completely different
than for previous versions.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Backup Priority level
• Prev in forum: Re: getting length of 8 characters
• Thread view: Re: How do I find out how full my files are?

[Reply to this message]