What that means is that at...

I believe that this is a limitation of "concurrent" snapshot in SQL 2000 but I am not 100% sure.

Can you try the snapshot in "native" mode?

Edwin (4/17/2009)

---

Hi Noel,

I created two index views:

-- t_Table_A_FirstView

-- t_Table_A_SecondView

on the Publisher database instance.

Next, I create a test publications with one article.

Then,...

Well I don't think it "negates" the purpose of replication in fact you are not the first trying this.

Once you have created the publication all you need to do is...

Sorry for the delay.

just create a normal job with TSQL task and EXECUTE sp_.... in it.

If there is a failure on the subscriber just make sure that the alert sends...

The "normal" way is that you call it on a created job in the primary and create an alert on the subscriber.

On the alert you specify your "notification" and you...

DBA (4/17/2009)

---

hi again, just to confirm, i can schedule the predefined data validation for rowcounts only three times a day eventhough the transactional replication runs every 2 minutes correct? they...

Although the IO "seems" faster the actual plan for the Partitioned table runs a nested loop over each partition. while the Nonpartioned table simply traverse one index btree. To notice...

Edwin these script are independent of the use or not of a remote distributor.

These are just run at publisher on the published database.

After you run it. You only...

Note that I used a 'pull' subscription and automatic synchronization those two can be different in your case but is all a matter of changing that to your needs.

UI is probably not good for doing...

HTH

Did you specified on the publication that the indexed view was to be replicated as "indexed view logbased" ?

I don't remember if 2000 supported that option.

Upgrading to 2005+ version...

\\K

You can definitely do as planned. tablediff.exe is a tool that comes with SQL Server 2005 and you already have it in your harddrive ;-). There are many examples...

DBA (4/14/2009)

---

thanks, basically i wanted to do one as a checkup of only the rowcounts to send an alert, so i just wanted it to run like three times...