hello.. is there a way to see all the changes that had been made to a databse in sql server 7.0 or 2000 from an application in visual basic 6.0??
thank You very much
I think the answer to your question is no. I assume you are asking if you can see an audit trail of changes made to the data or schema. In either case, the answer is no. At least not using standard SQL. There is no audit trail created by SQL Server. You must create your own history or purchase third party tools to track changes. Terry L. Broadbent - DBA
Computing Links:
I don't use any auditing tools. Try a web search. Using the search words audit "sql server" in Google displayed a number of links to SQL Audit tools. Terry L. Broadbent - DBA
Computing Links:
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.