Prev: MSSQL code to find all records within 1 year
Next: Problem with the cursor and dbname
From: David Kriz on 2 Jul 2008 12:00
Please, where I can see times when automatic file growth occurs?
I searched it in SQL-server Log and EventLog, but didn't found.
From: Aaron Bertrand [SQL Server MVP] on 2 Jul 2008 12:07
What version of SQL Server? 4.2? 2008? The answers to this kind of
question can change over time and between versions, so it is useful to give
us some context.

If you are using 2005 and above, you can see these events from the default
trace, at least as far back as the trace data goes.

http://sqlblog.com/blogs/aaron_bertrand/archive/2007/01/11/reviewing-autogrow-events-from-the-default-trace.aspx


"David Kriz" <david.kriz(a)ccv.cz> wrote in message
news:OOpqxyF3IHA.1192(a)TK2MSFTNGP05.phx.gbl...
> Please, where I can see times when automatic file growth occurs?
> I searched it in SQL-server Log and EventLog, but didn't found.


From: David Kriz on 3 Jul 2008 04:17
Sorry, my question is for "Microsoft SQL Server" version "2005, Standard
Edition, x64, SP2" which run on "Windows Server" version "2003, Standard
Edition, SP1".

Aaron Bertrand [SQL Server MVP] wrote:
> What version of SQL Server? 4.2? 2008? The answers to this kind of
> question can change over time and between versions, so it is useful to give
> us some context.
>
> If you are using 2005 and above, you can see these events from the default
> trace, at least as far back as the trace data goes.
>
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/01/11/reviewing-autogrow-events-from-the-default-trace.aspx
>
>
> "David Kriz" <david.kriz(a)ccv.cz> wrote in message
> news:OOpqxyF3IHA.1192(a)TK2MSFTNGP05.phx.gbl...
>> Please, where I can see times when automatic file growth occurs?
>> I searched it in SQL-server Log and EventLog, but didn't found.
>
>

 | 
Pages: 1
Prev: MSSQL code to find all records within 1 year
Next: Problem with the cursor and dbname