Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Monitoring File Sizes in SQL Server Part 3 Expand / Collapse
Author
Message
Posted Thursday, October 26, 2006 3:22 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, June 22, 2011 8:36 AM
Points: 28, Visits: 6
Comments posted here are about the content posted at temp


Post #318541
Posted Wednesday, November 08, 2006 8:23 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, February 23, 2007 12:30 PM
Points: 30, Visits: 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

 

 

Post #321326
Posted Wednesday, November 08, 2006 4:05 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, March 15, 2009 4:59 PM
Points: 1, Visits: 2

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

This is really useful.

Thanks

Post #321504
Posted Friday, November 10, 2006 8:46 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, December 19, 2013 12:41 PM
Points: 11, Visits: 43
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
Post #322128
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse