Have you recently renamed the server using the sp_addserver command? If so, did you restart the service after the rename?

I just had that happen to me with this scenario.

I...

Thank you both for your replies. GP - I...

Thank you, Mel!

SQLCMD - This is great! Thank you.

I think it's interesting that it failed when I used the following command:

:connect MyServer1 -U MyUserName -P MyPwd

We use RSA, so I thought...

Thanks, Elliott. That's a good suggestion that would be easy to implement.

I had a close call with running commands on the wrong server. I think I saw...

Never mind. Total "picnic" error! The job didn't execute.

Yes, I guess I got carried away. K.I.S.S always works best.

Thanks for the help, John!

Hey that's great! But how do I do that?

If I look at Project menu --> properties --> Configuration Properties --> Deployment Utility -->

AllowConfigurationChanges was already set to true.

Aha! This is what I wasn't doing:

Insert into #PersonID (PersonID)

exec prcTestLookup

I'm pretty...

Will the procedure return a record set? And if so, how can I do subsequent queries off of that returned record set?

I want to keep this as a procedure...

Yeah, that's what I was figuring was going on. But I don't know how to retrieve multiples. I didn't want to have to loop it based on...

I would agree that every shop has different needs. I'll toss out a few topics to get you started:

Recovery Models

Backups - full, diff, tran log

Restores - regular, point-in-time, with...

That makes sense. Darn nulls! Thanks. I couldn't have done this without your help.

I'm going to have to practice lots more with the !rbar.

Hey, thanks for the help!

I still get a unq constraint violation error, but I'm a heck of a lot farther than I was before.

(If you have to encrypt the columns, why is it ok to have them decrypted in a view? Didn't that just remove the benefit of having the columns encrypted?)...