The first thing that need to be done is to set up the distributor. Actually if you are setting it with defaults and simple replication, just follow the GUI. That...

there will be a slight degrdation but it is very small. Publisher has to notify the Distributor that there is a data change. So couple of small steps has to...

We are using two subscribers with real time publication. Snapshot should be done only once. There is no need to re snapshot it again and again. We use Push publication....

Glad to be of help.

You can create a temp table or a variable table and insert into the temp table the values you get from your SP's

DECLARE @TempTab TABLE

( lastName1VarChar(50),

firstName1VarChar(50),

address1VarChar(255))

insert into @TempTab...

Couple of ways to do this.

1. You can just back up your Test DB and restore it.

2. Detach TestDB, Copy the physical Files over to the VM instance and attach...

Please check this page to find out how to create Index views. This page even has FAQ. 🙂

http://www.microsoft.com/technet/prodtechnol/sql/2005/impprfiv.mspx

Please be careful when you are using Snap shot isolation. It uses quite a bit of Temp DB. IO will be higher. Performancwe will go down a bit.

I wrote...

Ross McMicken (1/20/2009)

---

If you use a decent one way encryption routine, you never need to decrypt the passwords. Just use the same encryption routine when the user enters their password,...

Right Click on the table and choose the option Open Table

Well, it is quite simple.

Server Number 1. The Publisher. That is your main production DB where all the transactions takes place. You do not want to disturb this set up.

Server...

It depends on how busy your DB server is. Keep in mind that you will have to have a Distributor as well. I will always go for three seperate servers....

This could be a potential problem. If I am not mistaken , you have the OS too installed in the same Drive. This could cause the OS to crash.

Look at @@RowCount

That should help

You can look up Encryption on BOL. That would be the best. Or let your App handle the encryption and save the encrypted data in the password Field. And decrypt...