Did you try re-rebooting? I saw that as a solution to a similar problem, but I can't find the actual thread now.

Please do not cross post, end the discussion at this thread :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=211707

What happens if you shortent the range of the search to let's say 2000 to 2001 so that the # of rows returned is different?

Yup but now he doesn't have to come back to the forum for these types of question, so that's 15 minutes everytime, assuming I saved him more than one question,...

Upgrade !!

No I don't know any other software than that.

What happens if you convert your db (a backup on another server) to 8.0 and document...

I rebuilt that query with the wizard in 30 secs... he had to at least take 1-2 minutes to type the question and wait 7 minutes for the answer (assuming...

I bet I can wizard that query before he hits post (and then starts waiting 2 minutes for an answer).

You might find this usefull :

--This will grant permission to the db_executor group for every stored proc in the system that he has no access permission to without changing...

There's where the view wizard can be your best friend in EM .

I'm surprised it even worked in the 2000 version.

You should ALWAYS, read ALWAYS specify the owner of the object (access, vb, sql...). And yes they'll need the permissions accorded...

Can you send the number of rows from that, time, and the plans too :

set statistics io on

set statistics time on

dbcc dropcleanbuffers

go

Select * from dbo.fn(null, null)

go

dbcc dropcleanbuffers

go

Select * from...

You're jumping to conclusion without us answering the question yet, we still need this :

Schema, Sample Data, Required Results

How about going the other way around.. create a table, add column CallingJob

Then when you start the job, first update that column, then the proc will be able to access...

I have a double edge, I think fast and type faster. Now you may have more experience but that doesn't atomatically translates in speed

Well how many rows are returned with each versions??