Schema changes to SQL Server

[System Audit]

I am working with an old version of SQL Server (6.5), but the same
mechanism may exist in later versions.

If there were any changes made to the database schema, would this be
recorded somewhere within the database?

Would there be some way of determining if there had been any schema
changes within the past year?

I am presuming all schema changes would be mediated by the SQL command:
"ALTER TABLE"

Thanks!

[Erland Sommarskog]

System Audit (pa*************@gmail.com) writes:

I am working with an old version of SQL Server (6.5), but the same
mechanism may exist in later versions.

If there were any changes made to the database schema, would this be
recorded somewhere within the database?

Would there be some way of determining if there had been any schema
changes within the past year?

I am presuming all schema changes would be mediated by the SQL command:
"ALTER TABLE"

No, they are not recorded anywhere. Not in SQL 6.5, nor in SQL 2005, the
latest version of SQL Server. In 6.5 up to SQL 2000 there is a column
schema_ver in sysobjects which is incremented by 16 when you perform a
change to a table, but that is not much.

Of course, they are in the transaction log, together with everything else
that has hapened to the database.

By the way, it's not much you can do with ALTER TABLE i 6.5...

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx