Friday, March 9, 2012

ms sql 7, tracking changes

Hi,
windows 2000 server
ms sql server 7
I am trying to track changes in the "options" tab in a particular database.
Specifically, I want to see when the "truncate log on checkpoint" was
checked. Are these changes logged anywhere?
Thank you,
kak37Possibly in the errorlog and EventLog. OR, you can have a Profiler trace running to capture the
changes.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"kak37" <kak37@.discussions.microsoft.com> wrote in message
news:F2CEE76C-1ECB-4933-B5F7-44A34D76B585@.microsoft.com...
> Hi,
> windows 2000 server
> ms sql server 7
> I am trying to track changes in the "options" tab in a particular database.
> Specifically, I want to see when the "truncate log on checkpoint" was
> checked. Are these changes logged anywhere?
> Thank you,
> kak37

No comments:

Post a Comment