Cursors and Concurrency - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Programming

Cursors and Concurrency

Author

Topic

heze
Posting Yak Master

192 Posts

Posted - 2006-09-21 : 14:39:29

In a previous post, the theme of cursors and concurrency was touched as a secondary subject. I have a specific question about it as the primary one:

if we have
--------
create proc myProc
as
declare cursor for
select * from mytable
go
----------
if two or more clients(webpages for example)
execute myProc concurrently will the cursor be safe ? or would I have to make special arrangements, there are a couple of procs (that use cursors)that somebody else did and would not like to modify but we want to make the procs web available,

thank you

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2006-09-21 : 14:45:21

See the following:
For SQL Server 2005 - http://msdn2.microsoft.com/en-us/library/ms191493.aspx
For SQL Server 2000 - http://msdn.microsoft.com/library/en-us/acdata/ac_8_con_07_6oxl.asp?frame=true

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2006-09-21 : 16:11:22

>>the theme of cursors and concurrency
There is a lot of info in Books Online as well (including this topic: Cursor Concurrency)

Be One with the Optimizer
TG

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources