I will try the maxdop option but wondered...The query works fine in production sp3a and maxdop is set to 0 on the server...Are you saying to try this with the...

I was thinking the cursor grabs the data and keeps it in temp table in TempDB and if the data is large enough that the temp table spans across pages...

I did see the process blocking itself using sp_who2.

I read the arcticle and had a question for those wiser than myself.  If the stored proc uses a cursor to go...

Sorry, been a long day...

Nothing in the Stored Proc that should cause multiple threads. 

Not sure what you mean about what the sp does(Far as I know bug fixes and security updates)

Server has 4 procs 1 gig of ram Windows 2000 SP4 OS

Could it be that SQL Server Agent or MSSQLService is running under an account that has expired?

One thing I would say is improve your database administration skills.  You seem to have good experience with T-SQL development, but DBA's also have to be very strong in backup/recovery,...

I used something similar to the above code, but you may want to select the data into a table first so you could validate your result set.

Thanks,

I realized after I posted that is probably what you meant.  But by then it was already up in lights.

Thanks Again

Erich

Thanks for the help.

I ran what you posted and it returned no results.  Am I missing something?

-Erich

What is the Server OS?

Are the flat files loaded from a different server?

If so, you might double check that the networking component MS DTC is enabled on the 2003 Server.  This has created issues for me when I...

Are the flat files loaded from a different server?

If so, you might double check that the networking component MS DTC is enabled on the 2003 Server.  This has created issues for me when I...

Thanks for the help, but I am trying to improve portability by not having to specify the server_name by using the /S and '.'

I am trying to get to a...

It looks like you might be specifying the object in your view incorrectly.  It looks like you are doing query on conso.conso.clients and maybe it should be conso.clients?

Post the syntax...