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

Another way to track the database data growth Expand / Collapse
Author
Message
Posted Monday, November 24, 2008 4:09 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, February 27, 2014 8:50 AM
Points: 1,114, Visits: 269
Comments posted to this topic are about the item Another way to track the database data growth
Post #607937
Posted Monday, December 22, 2008 8:06 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 10:37 PM
Points: 984, Visits: 1,325
It wasn't difficult to find the ???? in the script and was able to get it to run. However due to the nature of the way some of my databases are named I had to make a small revision to get the script to run completely. The line of code in both procedures is as follows:

'Use '+@dbName+'; '+

I changed it to:

'Use ['+@dbName+']; '+

and this was able to correct the problem. Thanks for the script. I have a project that was handed me to provision the production SQL Server box for 2009.

Kurt


Kurt W. Zimmerman
SR DBA
Lefrak Organization
New York, NY

http://www.linkedin.com/in/kurtwzimmerman
Post #623963
Posted Saturday, March 12, 2011 11:38 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, September 1, 2013 6:46 PM
Points: 21, Visits: 144
Hey Max,
While reading your article i checked the script in sql server 2005,
it was giving me the error.

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(7 row(s) affected)
Msg 111, Level 15, State 1, Procedure #uspGetFileStats, Line 9
'CREATE/ALTER PROCEDURE' must be the first statement in a query batch.
Msg 213, Level 16, State 7, Line 1
Insert Error: Column name or number of supplied values does not match table definition.

do you have any change in the script?

Saurabh
Post #1077344
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse