Antony Symonds (8/15/2012)

---

Im planning on running the insert on the subscriber... it will then I assume try to send that insert to the publisher and find it there..

Will this just...

HowardW (8/15/2012)

---

I'm not sure if there's an absolute limit. I can see a few suggestions that there may have been in SQL 2000, but nothing concrete.

I would strongly reconsider this...

Antony Symonds (8/15/2012)

---

Hi All,

So my subscriber server had a crash the other day...

The result of which meant that some row inserts didnt get replicated to the subscriber...

Replication is working...

Perry Whittle (8/10/2012)

---

This is incorrect.

A distributor may have...

muthyala_51 (7/27/2012)

---

i want to create a new distribution database and make the present publisher use this new distribution database.

sp_adddistributiondb

How can we achieve it ? What changes do i need...

SQLCrazyCertified (8/9/2012)

---

"SQL Server in a clustered environment: You just need to run edition upgrade on a single node, you can choose to run from either an active or passive node....

Sean Lange (8/9/2012)

---

MysteryJimbo (8/9/2012)

---

Lynn Pettis (8/9/2012)

---

First, you shouldn't use SET ROWCOUNT to control the number of rows affected by your DELETE statement. This functionality has been depreciated and may...

Lynn Pettis (8/9/2012)

---

First, you shouldn't use SET ROWCOUNT to control the number of rows affected by your DELETE statement. This functionality has been depreciated and may be removed in...

SQLCrazyCertified (8/9/2012)

---

saidapurs (8/9/2012)

---

Hi SueTon,

Please put SQL SERVER 2008R2 Enterprise edition DVD & give install after you will get MAINTENANCE option in their you will...

Developer edition has all of the same functionality as Enterprise edition. That includes clustering.

SQLCrazyCertified (8/7/2012)

---

Hi All, Please help/share your experience.

Here are my requirements.

Current Environment

SQL Server 2008 R2

Development environment

2 node Active/Passive cluster, Currently in standard edition

Need to upgrade to SQL 2008 R2 Enterprise...

Yes

Another thought. Sensitive data could also be encrypted.

lianvh (8/2/2012)

---

Good Day ,

our IT Auditors suggested the database administrators should not be able to view the Production data . Is there way to do that or should we rather...

sugnu iu (7/30/2012)

---

What i would like to do is to copy the database on the subscriber. I will copy just tge structure with no data.

Enable compression on the tables...