Re: sp_track_db_growth
From: Adam Machanic (amachanic_at_hotmail._removetoemail_.com)
Date: 12/02/04
- Next message: bpdee: "Prevent SQL Server from parsing code"
- Previous message: David: "Re: VIEW disappeared"
- In reply to: Marysa: "sp_track_db_growth"
- Next in thread: Marysa: "Re: sp_track_db_growth"
- Reply: Marysa: "Re: sp_track_db_growth"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 2 Dec 2004 13:47:39 -0500
Just a guess, since I've never used it, but there are two CONVERT(NUMERIC(x,
2), ... ) in there. Try increasing the precision of x in each of them.
-- Adam Machanic SQL Server MVP http://www.sqljunkies.com/weblog/amachanic -- "Marysa" <marysa@cma.ca> wrote in message news:eIDiS0J2EHA.3408@tk2msftngp13.phx.gbl... > I have added the above listed stored procedure to a number of my servers and > have been able t use it quite successfully on most databases. However, the > one database that I really want to find out the growth information....when I > run this storedproc, I receive the following error: > Server: Msg 8115, Level 16, State 8, Procedure sp_track_db_growth, Line 45 > Arithmetic overflow error converting numeric to data type numeric. > Does anyone know what could cause this? > >
- Next message: bpdee: "Prevent SQL Server from parsing code"
- Previous message: David: "Re: VIEW disappeared"
- In reply to: Marysa: "sp_track_db_growth"
- Next in thread: Marysa: "Re: sp_track_db_growth"
- Reply: Marysa: "Re: sp_track_db_growth"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
