Updates/Changes Log

15 Nov 2006 4:28 PM

David Saunders

Hi

I am interested in seeing all upgrades and change made to a SQL 2000
database. Are there are any logs kept in SQL 2000 that tell you all of the
changes and upgrades made to the DB since installation?

Any help is much appreciated,

David

15 Nov 2006 11:57 PM

Aaron Bertrand [MVP]

No, SQL Server 2000 does not keep track of this information...

Show quote

"David Saunders" <DavidSaund***@discussions.microsoft.com> wrote in message
news:DE8F7AAA-E973-4257-A40F-9E5866EEC1B5@microsoft.com...
> Hi
>
> I am interested in seeing all upgrades and change made to a SQL 2000
> database. Are there are any logs kept in SQL 2000 that tell you all of the
> changes and upgrades made to the DB since installation?
>
> Any help is much appreciated,
>
> David

16 Nov 2006 3:56 AM

Hari Prasad

Hello,

SQL Server 2000 will not keep track/log of changes by default. If you have
olderror logs you could verify the SQL Server error logs to check if there
is anu version change.
For DB Growth and all you will have enable the Profiler events and log to a
file;which is resource intensive as well as needs lots of storage.

Thanks
Hari

Show quote

"David Saunders" <DavidSaund***@discussions.microsoft.com> wrote in message
news:DE8F7AAA-E973-4257-A40F-9E5866EEC1B5@microsoft.com...
> Hi
>
> I am interested in seeing all upgrades and change made to a SQL 2000
> database. Are there are any logs kept in SQL 2000 that tell you all of the
> changes and upgrades made to the DB since installation?
>
> Any help is much appreciated,
>
> Davidy