Thanks for replying ianscarlett.

But I read a document in SQL Server 2000 Resourec kit, which says the following:

Since the log shipped database is only a small increment of time out...

Thanks for the solution. I tried using SQL Profiler Objects Event. But it does not work.

Object:Opened and Object:Closed is supposed to work for SELECT, INSERT and DELETE. But it ...