Help. I can't remember the procedure I need to run to sync orphaned users in a database. Please help me.....

Really? You want us to work with just a partial piece of code? I don't think so. How about posting the entire query or at least the...

GSquared (5/28/2009)

---

Lynn Pettis (5/28/2009)

---

I like using surrogate keys as a primary key, but I will...

At the rate we are going, I wouldn't be surprised if we hit 6,000 by June 30th. 😛

I like using surrogate keys as a primary key, but I will also identify a...

If...

Richard Driscoll (5/28/2009)

---

oh come on! How does N-Var-Char translate to this answer!

I hesitated to answer because none of the anwers seemed correct and when I finally did I was greeted...

Just a follow-up, how is your testing going?

john.arnott (5/28/2009)

---

I apologize for jumping in by posting a question on one of the echo threads that Gail shared. Didn't realize that consensus what that to leave it to Steve...

Steve Jones - Editor (5/28/2009)

---

I read that gem. Had to read it twice to be sure that I wasn't misreading things.

Shaking head here all the while. Some days I think...

Here is my suggestion, do your backup to a local directory, then move or copy the file to the other server. From what you posted, I couldn't tell you...

GSquared (5/28/2009)

---

Yes, you can run them at the same time in 2005. I've had some IO bottlenecks from concurrency in that case, but it's potentially not a big deal.

On...

We have a parrot on the site who is mimicing advice or giving really bad advice. For example, check...

Pardon me if you have already answered this, but which instance (or instances) of SQL Server are you unable to connect to remotely?

Anyone catch this little gem?