You'll have to debug the procedure... I can't help you on that part. You'll have to figure out what's hapenning.

Is the error coming from the files, or from the import?

I'm still looking at it and I still don't get it... can you share the idea behind this technic?

Can we see the while code?

Actually it's the other way around. Change the query, if there's still a timeout, then correct the timeout limit on the apllication side

Don't run the plan, just tell me what you see. What part of the plan takes the most time (in %) of the query. If you have something...

One thing you must know about sqlserver managing ram is that it'll take all you give to him for faster data access. If you have a 1 gig db...

HTH.

The short answer would have been to use the system procedure sp_renamedb 'oldname', 'newname' in the first place to do this.

Maybe it'll still work in this case but I doubt...

The real question is why do you have to reboot the server? What is the bottleneck (cpu/disk/ram).

When are you doing this importation (off hours when the site is not...

assuming that the select query works, just remove the values keyword and the parenthesis around the query (they are optional).

Which doesn't seem extremely slow. It's not fast but it's hard to judge without the rest of query and the table size...

Now can you look up the execution plan...

Change B.* to a column name that is not a text/image column, or to a constant like 1.

Please do not cross post. I already answered your question here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=191642

Define big (1k, 1M, 1B rows???)

Is the where condition sarg (look up bol for this one)?

How long does it take to simply select the data from Oracle without redoing any...