Same result as attach db in most cases unless you are restoring the master on the other server.

"Don't roll your eyes at me. I will tape them in place." (Teacher...

You might want to post that to the FAQ section as a possible solution since other may come accross this problem and be looking for a way to fix.

"Don't roll...

Please post your script (alter any sensistive data) so we can look and maybe someone will catch an error.

"Don't roll your eyes at me. I will tape them in place."...

Use bcp with the /e errfile command switch. This will allow you to specify a file with path for errors to be wrtten to then you can go back and...

Well you know you should stay subscribed to your own post and as with any solution the first may work but may not be the best and keeping up with...

Ok try one last thing, open the package on the server and then do SAVE AS and save a new copy. Then see if you can open it. If so...

If you are using 6.5 I think there is nothing you can do. If 7 there is a script here http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=26 that will shirnk the log, once done with and...

For Access it is InStr function that returns the position of the first occurance of an item.

SELECT LEFT(QuestionNumber,INSTR(QuestionNumber,'.') - 1) AS Expr1 FROM tblX

"Don't roll your eyes at me. I...

Great to hear. Was there anything off from what I stated you had to do in case someone else sees this thread with the same problem?

"Don't roll your eyes at...

Which database? If is tempDB then stopping and restarting automatically should fix. If not the stop SQL and delete tempDBs data and log files and restart SQL, it will automatically...

Sorry I have never needed (knock on wood) to do this. I would think no too very long considering I believe it more or less just puts a new copy...

Also if this is a fairly large dataabse that has been running for a while the stop and restart would have cleared the query cache and query plans of eveything...

Ok I will try it this way to see if I can reproduce. It would seem odd giving you troubles inside the SP.

"Don't roll your eyes at me. I will...

I have never heard of any that pay, but if you find let me know.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Some of these are really good causes but there are some out there that I on a personal level have issues with in that they are owned by private companies....