This is also a great way to garantee an index scan... this is not a sarg condition.

Don't worry about my attitude... didn't come this far shying away from problems.

I'm glad I don't have to code that monster up .

That fails too... that's why we're all stumped :

use finance

select TOP 10 *

from sysobjects

Results:Server: Msg 170, Level 15, State 1, Line 2

Line 2: Incorrect syntax near '10'.

use pubs

select TOP 10...

Let me rephrase that... is there a way to break down this operation? Seems like a lot of stuff is going on and I do see all that many...

Are there other objects that use the order by? Do they work?

Don't remember,,, I usually use

while X>0

...

wend

I forgot the other 11 versions of the loop .

Seems like a pretty big form... any to split it in smaller forms???????

Also I still think that it's the best way to go.

HTH... even if it's just a grain of salt .

Have you run the standard dbcc checks for the db?

Yup... this one is really hard to catch...

Have you tried copying the db to another server and see if it does the same thing there (to expose the server as...

Hehe... that's a nice gotcha!!

How much time did you lose on this one?

I had thaugh of this one too. But it worked right down to 60 so I didn't bother to ask him .

create database...

I seriously think that you don't need a cursor for this. Do a initial insert of all the objects with a count of 0.

Then do a

select ObjectName,...

You mean in Data / control source?