Are you saying that your application is creating a new database every day?  If so, thats a lot of databases!  If this is an in house application, you really should...

rpetty,

The usage of the transaction log file can be EXTREMELY dynamic.  If you are loading, deleting, updating large amounts of data during a batch process, or rebuilding indexes, the transaction...

The dynamic sql gets around the limitation of using "USE" in a stored procedure.  The problem with Phil's code was that a stored procedure cannot be called using only the...

Bear in mind that as stated, it will give you the first seven records it happens to find, in no particular order.  Could be the first row inserted, 17th, 159th,...

The thousand dollar add-in is Lumigent Log Explorer (actually, I don't know the price).  http://www.lumigent.com

When I think of a log, I think of a file that I can look at as...

You're absolutely right.  I was looking at the wrong procedure.  The procedure that I have that gets the total space is basically the same as the one Frank posted.

Sorry for...

Its not compressed.  If you look at the backup size, it'll be the utilized part of the data file(s) + the utilized part of the transaction log file(s), at least...

The DOS DIR command will give you the drive capacity, but you'll have to parse the information out of the results.  I've done this in a stored procedure, but you said...

By the way, our host, Steve Jones, wrote 'dbspCalcdbaSpaceDist' stored procedure, which pulls this information.  I think the procedure is available on this website.  There are a couple of minor...

Take a look at 'dbcc sqlperf( logspace)'.  One caveat though.  If there are multiple

log files, it will aggregate the data rather than providing stats for each file.  There doesn't seem...

Hey, alzdba,

I like that renaming of the job!  Makes it easy to tell at a glance that its disabled!

Steve

Henk,

That is a GREAT story and explanation!  Glad is solved (at least for now!)

Thanks for letting us know!

Steve

I think thats where your problem may be.  You should never update the system tables directly.  There are many "behind the scenes" things that you can't possibly take into account. ...

Be aware that SQL will create the MSSQL folder and the subfolders beneath that where ever you tell it.  So, if you select d:\SQL_Data\ as the location, your master data...

There is a bug that affects job scheduling, but this doesn't sound like it.  Just make sure that you are on the latest service pack and you'll be ok as...