One of My upgrade from sql7 to sql2000 slow a sp from 30 minutes to 1 hr, which contain cursor operation. I have to rewrite the sp and take out...

I don't think sp spStaticNoStopOnFirstError can continue if the first query run into an error.

Thanks for the input.

I may confused you guys by saying "named instance", actually from the server (say instanceserver) which is running named instance, I cannot run "isql -S otherservers", not...

yes, it's started, I have several sql 2000, most of them working with "isql -S" and "bcp -S", only one that running named instance is not working. I changed registry...