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 Development (2000)
 Use Checkpoint in Stored Procedure

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-01-24 : 08:44:05
puneet dhall writes "Hi,

Can i use checkpoint in cursor?

Problem: I put 500 insert statment in a cursor and execute one by one. On each insert statment i append the checkpoint but if i execute the same statement in query analyzer it works fine
Please reply ASAP"

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-01-24 : 08:44:57
You can, if you want to slow the process down even further than it already has been from the cursor.
Go to Top of Page
   

- Advertisement -