Friday, March 30, 2012

how to verify if db option has been changed by user / appliacation

Hi,
SQL Server 7.0 (SP4) on NT 4 (clustered)
is there a way to verify if database option (ex.: select into) has been
changed by user / application (who, when, etc..) ?
Thank you
DannyNot directly, but you can use the tools from www.lumigent.com to trail
through the transaction logs and find it out from there if your database is
fully or bulk logged.
--
Jacco Schalkwijk MCDBA, MCSD, MCSE
Database Administrator
Eurostop Ltd.
"Danny Presse" <danny.presse@.sympatico.ca> wrote in message
news:3F059A77.2B983D4E@.sympatico.ca...
> Hi,
> SQL Server 7.0 (SP4) on NT 4 (clustered)
> is there a way to verify if database option (ex.: select into) has been
> changed by user / application (who, when, etc..) ?
> Thank you
> Danny
>
>

No comments:

Post a Comment