see changes

[elibb]

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

Eli

 

[tlbroadbent]

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:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[elibb]

yes thats exacty what i want..
do you know any tool i can use??

thank you

eli

 

[tlbroadbent]

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:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[elibb]

thank you very much, ill look for it.. otherwise i will do it by hand (i was trying to avoid that part ;-) )

Eli

 

[mapfax]

If it helps, I found a good article about creating Valid Time Tables for auditing purposes.

http://www.accesshelp.net

> survival guide.

Mark.