Hi Alan -

Thank you for your response and confirmation. I figured there was a reason why the Redgate tools existed (specifically for schema and data compare and pushes).

I...

Jacob Wilkins (5/9/2016)

---

Or this thread you were in http://www.sqlservercentral.com/Forums/FindPost1292860.aspx 🙂

At any rate, as pointed out in both places, the main thing is that it's easier to get the function behaving...

You know what? I think I found it. It kind of looks like what she had to say, and is from 2012, but I specifically remember her saying...

That actually was the one that I found while looking for the one I was referring to here in my initial post. The mention from Gail I'm referring to...

Guess I will answer my own question here. Though it does not specifically state that it is for Bidirectional Transactional Replication, it does state plainly (while speaking about everything...

I went with something different, but I appreciate the direction here.

I had been using this script in a past life for the past 3 years, and thought I had lost it forever. I forgot from whence it came! ...

thank you so much! I will test this out, and yes - I normally treat all my DML as Transactions, but here in my new position - they do...

Hi Gail - thank you very much for this feedback.

What I wound up doing was taking a backup of each of the databases, and restored them into a new database...

As a sort of group answer - here is the output to 2 of the databases that got whacked:

DBCC CHECKTABLE

I did run this previously (to see if I couldn't...

It's a horribly designed database, and it often times has HIPAA/PHI data in it. The thing that bothers me most is the nonchalant way that it was used in...

Honestly - I think it would just be better to give explicit perms to the designated user in this situation, because as you pointed out (and pointed out quite well),...

george, thank you! I did some searching as well after our last exchange here, and found some things from trusted sources that led me to the same conclusions you...

Can you provide any links to share where it states that SP2 CU1 is all that is needed? I ask because if there is conflicting information out on this,...

Hi george -

Sorry - I meant 'fixes' when I said 'securities', but here is what I was referring to...

The initial release of Service Pack 2 (11.0.5058) does not contain...