|
Home > Archive > MS SQL Server > November 2006 > Update Logs/Monitoring
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Update Logs/Monitoring
|
|
| David Saunders 2006-11-15, 7:14 pm |
| 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
| |
|
| When you say upgrades, do you mean within your own database upgrade schema
or do you mean like from running a SQL service pack?
What do you mean by changes?
"David Saunders" <David Saunders@discussions
.microsoft.com> wrote in message
news:EB8A132B-453E-4EB5-B03C- 967B11124991@microso
ft.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
| |
| David Saunders 2006-11-15, 7:14 pm |
| Immy,
I am looking for information on both upgrades (e.g. service packs, upgrades
to versions running, etc.) but also any major changes to the database
structure (e.g. the addition of new tables, the removal of relationships,
etc.). Is this at all possible? Possibly through more than one log?
Many thanks again,
David saunders
"Immy" wrote:
> When you say upgrades, do you mean within your own database upgrade schema
> or do you mean like from running a SQL service pack?
> What do you mean by changes?
>
> "David Saunders" <David Saunders@discussions
.microsoft.com> wrote in message
> news:EB8A132B-453E-4EB5-B03C- 967B11124991@microso
ft.com...
>
>
>
|
|
|
|
|