Crap.. that was a short lifetime. I'm pretty sure that the swap can be done but I never tried it so I can't be sure. However I do...

Yes... but I think you can simple copy your current db files and reattach them on the new server... don't know if it's doable with the system dbs but it's...

AAAAhhhhhh!!! unit testing = quality assurance .

Makes more sens now .

Sorry, slight misunderstanding... did you get my PM?

How would that work Noeld... I usually just call the sp from the app using a command object... and this where the code fails for me.  I don't see how...

Were you able to restart them?

Can you restore to an earlier point of windows (just b4 the install).

If not I'm afraid you'll have to rebuild the server.

Wow, that's much more polite than what I wanted to say.  Let's leave it at that for now... also I'm very glad you don't work for N.A.S.A, they have enough...

Are all the services started?

I've never seen that error. But it looks like you might have some corrupted dlls from the hard shutdown. Maybe you'll have to reinstall...

Good, now we can close this thing.  Make sure you look up the split versions we showed you as they're set based and faster than this one.

When you transfer objects, you also transfer the logins by default, so the old ones might have been dropped.  Can't you login to the server yourself using the sa account?

Check if the users/login are still on the server. What's the server's authentication mode?

What does the windows log say?

The problem is not the right() operation. The problem is that this operation forces the server to do a scan of ALL ROWS to check for a match. ...

Yup there's just no need to use a cursor to split the values with the cursor... I don't wanna get started on that either