MSSQL 2000: How can we track table/sp/function changes?

My company would like to start keeping track of everytime a table, stored procedure, or function is changed.
What is the best way to do this?Option 1)
Create a database for storing metadata on all the other databases. Nightly, run a query that loops across all database and records all the objects along with their checksum values, and notes any objects who's checksum value has changed.

Option 2)
Upgrade to SQL Server 2005 and create database triggers to log changes to objects.|||sourcegears vault, visual sourcesafe. nothing makes it into our software\database builds that is not in our sourcecode management software.|||Revoke sysadmin/DBO rights from everyone but the DBAs.|||As suggested you cna take help of Visual Sourcesafe or PVCS in order to take care of object changes.

MSDTC Event ID 53286

I have a SQL Server that keeps throwing errors in the Application Log.
I cannot seem to track these down, and I have checked Microsoft and
EventID for information. Here is the event:
Event Type: Warning
Event Source: MSDTC
Event Category: XATM
Event ID: 53286
Description:
The XA Transaction Manager called the "GetXaSwitch" function in the XA
resource manager DLL. The call to the "GetXaSwitch" function failed:
File=.\xarmdir.cpp Line=580.
Can someone shed some light on what I need to do to resolve this
problem?
Thanks in advance,
J Wolfgang GoerlichI do not know what that DLL is used for, but I would first verify using SQL
Profiler if the XA transaction makes it all the way to SQL Server, by
looking at the Distributed Transaction Event Class
BTW: If you are using Oracle 8 or 9 you should be using: "Oracle Services
for MTS in Oracle9i"
http://otn.oracle.com/tech/windows/ora_mts/htdocs/oramtsfov9i.html
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2003 All rights reserved.
"jwgoerlich" <jwgoerlich@.quantaonline.com> wrote in message
news:9c87d620.0308290628.5843fe3e@.posting.google.com...
> Funny thing. I solved this one by recreating the DTC log (msdtc
> -resetlog). Now I am no longer getting that error. I did notice that
> the MTC is trying to load a ENUdtcl.dll file from the Oracle folder,
> and this file does not exist. Any one have an idea on what this is
> used for, or should I not worry about it?
> Thanks in advance,
> J Wolfgang Goerlich