ashish.kuriyal (8/17/2010)
then in that case I think we need to setup the auditing on every connection getting connected to database.
Indeed. The only way to guarantee that you are getting all activity associated with a given database would to be to collect all select, insert, update, delete, procedure exec, etc for the whole instance and then analyze that data. There are several ways to go about doing that but this is something typically associated with SOX type compliance etc.
If there is any additional information on the purpose of the project that the OP can provide that would be helpful in recommending the most comprehensive solution.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot