SQLServerCentral / Discuss Content Posted by Roy Carlson / Article Discussions / Article Discussions by Author / Monitoring File Sizes in SQL Server Part 3 / Latest Posts

RE: Monitoring File Sizes in SQL Server Part 3

Brian Pastre — Fri, 10 Nov 2006 20:46:00 GMT

I have tried this script on several different servers and computers and keep receiving the following error:Line: 86Char: 1Error: Unknown Runtime ErrorCode: 800A03ECLine 86 executes the following:oExcel.Range(strNewCell).ActivateI am curious to see how this report runs.Thanks,Brian

RE: Monitoring File Sizes in SQL Server Part 3

Alastair Stuart — Wed, 08 Nov 2006 16:05:00 GMT

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

This is really useful.

Thanks

RE: Monitoring File Sizes in SQL Server Part 3

Muralidharan Venkatraman — Wed, 08 Nov 2006 08:23:00 GMT

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

Monitoring File Sizes in SQL Server Part 3

rscarlson — Thu, 26 Oct 2006 15:22:00 GMT

Comments posted here are about the content posted at temp