From what I saw in Twitter, there were some ladies who were inquiring about this party. Maybe this year you will have more ladies. (Especially since they all know that...

Initialization can be done using Back up. If you do not need all the tables in the publisher on the offshore DB, replication is more suited.

But like Derrick mentioned, Log...

The try catch will catch only the last message since usually the first message gives the information and the last one gives the final result (Terminating message).

One thing you...

How big is the database and how much data gets changed?

As far as I can see from your scenario, you have two ways of getting this done.

1. Log shipping. Using...

Let me also congratulate this site for hitting this milestone. 🙂 So Alvin, what did you get for hitting the milestone? Are you going to get the Alvin and the...

Anybody looking for chairs or recliners?

How do we report spam?

That would probably mean that you are securing on two levels. One is based on NT security and the second level of security is separate DB instances. I do not...

Do each of these customers have physical access to their database files?What kind of user rights do each of these customers have on their database?

If you give physical access...

Congrats Alvin... You did it..!!!! Great Job.. 🙂

When you created the certificate, the expiry date you had given must have passed. One thing that can be done is Alter Symmetric key and drop the encryption that is...

Gail, reminds me off the PMs at our work. The PMs we have must be related to the PM that you are teaching now... 😉

There is a small catch in the "The "Synch With Backup" option on the distributor DB and the publisher DB is important for how you want to be able to...

The distributor can be set up in Simple mode. I do not see why you will want to keep it in Full mode.

No one uses that forum. That is the only problem. If you want to get good insight, this is the place to discuss. Maybe we should ask the chapter leaders...

Alvin Ramard (10/4/2010)

---

Roy Ernest (10/4/2010)

---

I will be sending an email to my members regarding the next topic they would like to see in T-SQL. That I think is the best...