January 26, 2009 at 3:05 pm
Does anyone know how to quickly find database autogrow status and report on it?
Tnx
January 26, 2009 at 3:28 pm
check out sys.database_files system view.
http://msdn.microsoft.com/en-us/library/ms174397(SQL.90).aspx
January 26, 2009 at 3:30 pm
If you are not already somehow tracking this on your own, I believe that the only way (that I know of anyway) is to go to the error log to get this information.
Something like
create table #testlog(dt datetime, info varchar(200), errtext varchar(max))
insert into #testlog
exec sp_readerrorlog
select * from #testlog where errtext like '%autogrow%'
ETA - and this will only work if you have an alert set up to check for Autogrowth. Sorry for not clarifying originally.
January 26, 2009 at 3:58 pm
Robert, sys.database_files will work for SQL 2005, any idea how to implement it with SQL 2000 as well?
January 27, 2009 at 7:39 am
sysfiles has mostly the same info in 2000
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply