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)
 nolock

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-12-03 : 07:57:31
David writes "Can not contiunue with data scan due to noluck.Any solution?"

nr
SQLTeam MVY

12543 Posts

Posted - 2004-12-03 : 09:01:57
Get more luck?

Maybe a bit more info about what you are doing.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2004-12-03 : 16:14:26
Hey Nigel, besides being funny,

Do any ASK SQL Team posters ever read their responses?



Brett

8-)
Go to Top of Page

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2004-12-03 : 16:33:54
I don't! hehehehe

rockmoose
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2004-12-03 : 16:39:07
I hope the ones who get "we don't answer homework questions" do, hopefully they'll stop posting them.
Go to Top of Page

Bustaz Kool
Master Smack Fu Yak Hacker

1834 Posts

Posted - 2004-12-03 : 18:21:03
Use the Performance Monitor to see if the Luck resource is having contention issues. If the Counter drops to zero then you're SOL.

HTH

Go to Top of Page
   

- Advertisement -