SQLCrazyCertified (4/27/2012)

---

Gianluca Sartori (4/26/2012)

---

I was wondering how to implement HA for a merge replication subscriber.

Given that:

* mirroring is not an option (by desing)

* clustering still has the storage as a...

MysteryJimbo (4/27/2012)

---

Why? You can have two servers using mirroring and have the publisher use a DNS alias for the subscriber name....

Dev (4/26/2012)

---

Please correct me if I am wrong, isn’t merge replication publishers & subscribers interchangeable and both servers can play both roles (primary & secondary).

May I know why you are...

Duplicate post.

Replies here please:

http://www.sqlservercentral.com/Forums/Topic1291303-391-1.aspx

I don't understand your issue. Can you please clarify?

Maybe including some sample data and an expected output based on the sample data would help clarity.

Thanks for the link, Dev.

Unfortunately that page describes how to set up log shipping on the publisher, but I'm looking for HA on the subscriber.

I haven't tried log shipping, but...

I would wait for this to happen again and investigate the issue logging in with DAC.

High CPU could prevent the instance from accepting new connections, but it's hard to tell...

Voted!

You're welcome.

Glad I could help.

Yes.

They can be used to capture audit...

S_Kumar_S (4/24/2012)

---

Hi Gail

Then it leads me to the question "why on earth we need table variable then?"

Temp table also stays in memory if data is less. Temp table even has...

It can't be done exactly they way you put it, but you can use CROSS APPLY to pass the column's values to the function:

SELECT *

FROM MyTable AS MT

CROSS APPLY...

You're right, SQL Server decides on its own how to handle the "shift".

However keep in mind that ALL tables are populated like that. I don't know where the "table variables...

As a side note, this bug has been fixed in SSMS 2012.

You could install it and use it even against a 2008 instance.

Great!

Glad I could help.