Monitoring File Sizes in SQL Server Part 3

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Muralidharan Venkatraman Old Hand Points: 386 More actions · Answer 1

Thanks. That's a great script which is very useful.

The good side of this script is you can monitor individual db.

The downside is the drive and path is hardcoded and if we move the datafiles to a different drive / change path, the script would fail.

Otherwise, this is a really useful utility.

Great job.

Thanks

Murali

Alastair Stuart SSC Enthusiast Points: 105 More actions · Answer 2

Bloody Brilliant!. I'm not into scripting but the last three days have shown me its value.

This is really useful.

Thanks

Brian Pastre SSC-Addicted Points: 494 More actions · Answer 3

I have tried this script on several different servers and computers and keep receiving the following error:

Line: 86

Char: 1

Error: Unknown Runtime Error

Code: 800A03EC

Line 86 executes the following:

oExcel.Range(strNewCell).Activate

I am curious to see how this report runs.

Thanks,

Brian