Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Sql Queries

Author  Topic 

pavan_kashyap
Starting Member

2 Posts

Posted - 2006-03-01 : 11:23:37
Is there any way to check 1-2 days prior sql queries executed..??

However, i am going for auditing now.

Thanks,
Pavan

JoeNak
Constraint Violating Yak Guru

292 Posts

Posted - 2006-03-01 : 11:28:40
You can leave a trace running, but that will add a load to your server...
Go to Top of Page

pavan_kashyap
Starting Member

2 Posts

Posted - 2006-03-01 : 11:45:20
I wanna see the queries which have already executed(2 days back), i have my trace started now.
Go to Top of Page

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-03-01 : 12:17:55
u cannot c the old queries, u can c the queries from the time u started it. eg. after another 2 days, u can c the queries u that u ran today
Go to Top of Page
   

- Advertisement -