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
 Transact-SQL (2000)
 Setting up snapshots

Author  Topic 

scelamko
Constraint Violating Yak Guru

309 Posts

Posted - 2005-02-25 : 14:39:39
Guys,
I have question abt taking/setting up snapshots.
I have only a pretty rudimentary idea abt it.
I have long query which taking a long time to show up the results, I want to set a snapshot for that particular query.
Should I set it up as a schedule job, basically what is the better way to set it up from Enterprise Manager so that
I can analyze the same.
Any comments/insights/suggestions would be very helpful

Thanks
   

- Advertisement -