January 4, 2006 at 3:14 am
How to find recently updated table in sql server
1> waht must be done for enabling audting
If not any other way to do so ?
Thanks
January 4, 2006 at 12:05 pm
You could use a trigger to write a row to an auditing table everytime an update happens. Or, you could include an insert statement in the process that runs the update to write a row to an auditing table.
January 4, 2006 at 11:57 pm
Thanks for the reply . Apart from using triggers is there a way out to find out from systables specific to the database.As of now this process of using trigger is not set. Any other way out??
January 5, 2006 at 3:57 am
Hello Geetha,
You may have a look at the below articles to enable auditing.
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlc2.mspx#EGAA
http://www.databasejournal.com/features/mssql/article.php/3399241
Hope this helps !
Regards, Arul.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply