MysteryJimbo (1/5/2012)

---

Roy Ernest (1/5/2012)

---

You do not have to create / modify every object by hand on your subscribers when using Transactional replication. When creating a new table, just add one...

You do not have to create / modify every object by hand on your subscribers when using Transactional replication. When creating a new table, just add one more step to...

Sure, it is possible. Are you talking about restoring in production server by anyone? Or are you talking about a test environment?

Congrats Koen... That is wonderful news. A good start to your new year... 🙂

Our company does not own a casino. 🙂 And jason, even if you played the casino, it wont hurt the casino owners. The odds are stacked against the players... 😀

Before I forget, Let me wish you all a very happy and prosperous New Year, 2012.

We have a Special server where we restore, Scrub the data and then back up this DB abd send it over to development team.

Local policies on your work station. Firewall on your work station. Those are the two things that stand out that could cause issues like this.

Regarding RDP, I was asking...

Did you try RDP into the server and trying to connect? If that is working like it should then you can definitely conclude that it is not your Server installation...

There is no difference in using order by in Stored proc or adhoc. Please post your SP script.

I know all of them. Had the chance to interview them. All of them were strong candidates. I knew that there would always be disappointments.

In a warehouse, TBH Read Uncommitted or NO LOCK is not as bad as everyone says. OK, I have said it. You can all start cussing me... 🙂

I have a feeling that they are one of them was talking about the SQL Pass Election.. Maybe I am mistaken... 🙂

You can use sp_addsubscription fo0r each new subscriber you have.

Me too...