My update from publisher will update the MONO.USER_MASTER table as well as the same table on subscriber. On Subscriber , we have defined the trigger to update FLI.USER_MASTER table.

Also I...

actually I don't receive any error. This a replicated update data from publisher to subscriber. Trigger is defined on subscriber.

If I update on the subscriber I am able to...

Thanks it helped.

this is something new to learn. I am curious to know what all these settings. I will check and update you.

Meantime , I have asked them to add cluster index...

No do not have cluster indexes the tables are over 90% fragmented. I am also continuously seeing deadloack

before the outage with High CPU and many user connections.

What is your input...

Yes I will be updating table stat today , this is a million rows heap table. we had done a rubild indexing but did noit helped last week

As per the...

Thank you for sharing your thoughts.

I will try both the options to merge and to use stage table.

Let me first try stage table and then switch off the data...

Thank you all, yes am also planing to follw the advice by loading through staging table. My main table is paritioned ( did it now ) on yearlywise so to...

Thanks Kevin for the wouderfull explanation.

Thanks Kevin , If I consider only HA solution , is fasttrack databases support all the features of MS SQL Server 2012 ( Always ON) ?

If yes, do the fasttrack...

New persopn (7/18/2013)

---

Hi all

Here we have to setup cluster environment for one of my client.

Here we are having the 500gb hard disk and 8 instances.

in that 4 applications are running.

can...

I have recently did setup 2012 always on with 2 active/passive node with different NW subnet adding another instance in the AAG to be the mirroing. This is working fine.

Any update ? I ahve tried almost everything

checked the permission SSRS service account have full permission on E

config file have the path name and spelling is correct

http://support.microsoft.com/?kbid=913046# I have...

It will take only one connection.

hmm. Is it possible to have two sans attached to box and configure it so the cluster also could see it. The second san will be the replica of 1st...