Richard Teachout - My technobabble Blog

Search this Blog

KeywordsPhrase

Links I like to keep around

	View All Recent Entries
	Great Websites to Visit!
	Linux - PBX (asterisk/freepbx)
	Linux Stuff
	MS Virtual Server
	MSSQL Scriptlets
	Ramblings
	VBS / Administration Scriptlets
	Webmin Blog
	Windows & IIS stuff

Here are the most recent postings to this blog. Use the archive calendar or search to find other entries.

SQL:Determine MSSQL Database + DBLog Used + Allocated Size

Nov18

Written by:R Teachout
11/18/2006 8:23 PM

use your_db_name;
select name, size/128 as physicalsize, maxsize/128 as maxallowed from sysfiles;
 
 
Voila.. that's it!  Easy!

Trackback Print

Location: Blogs

Ramblings, Scriptlets, and more!

MSSQL Scriptlets

Tags:

0 comments so far...

Your name:
Title:
Comment:

Security Code Enter the code shown above in the box below
Add Comment Cancel

Even as a longtime critic of the company, I must admit that Microsoft occasionally flirts with the truth. Well, perhaps 'flirt' is too strong a word. Let's just say Microsoft sometimes honks and waves as it drives by her house.
-InfoWorld Editor Nicholas Petreley, 06-14-99