That's what I thought, but it isn't what I'm seeing.

I deliberately have an invaid entry when I apply the FK (with NOCHECK), just to see what happens.

sys.foreign_keys has 'is_not_trusted' set...

I never use the GUI, because it doesn't cater for the way we work here.

There is an Technet page for dropping/adding Articles with the GUI. You'll have to read...

I do this type of change on a regular basis, so your steps should be something like this (this is for a Pull Subscription):

1. sp_dropsubscription & sp_droparticle, to remove this...

Do you mean the schema differs between the Publisher and the Subscriber?

If so, we have this situation here and it can be done via scripting (I haven't used the Wizard...

Do you use snapshots within this Publication?

If you script the current Publication is '@immediate_sync' set to true or false?

It might be the snapshot either refreshing or being created from...

If you need to test for any interesting postcodes: http://www.softwaretestingclub.com/forum/topics/fun-postcodes-to-use-when-testing?id=751045%3ATopic%3A164159&page=1#comments

Sean Lange (1/23/2015)

---

Oh the cursors are unbelievably stuipd. They are used to count!!!

set @Counter = 1

while exists(select * from StupidlyLargeHeap (nolock) where someColume = @Counter) begin

set...

Stefan Krzywicki (1/21/2015)

---

Anyway, hi! I'm Sioban. Sioban Jeanne Krzywicki. If you want the full name (that it'll be as soon as I finish all the legal paperwork, probably a month...

Well that changes the picture...

Mauricio_ (1/19/2015)

---

Hi all,

I have a question regarding performance. I need to alter several tables, changing columns from decimal(18,4) to decimal(19,8). Some of the tables have...

Can I ask first of all why is the use of NOLOCK compulsory, and are you aware of the potential problems that such a strict rule can cause?

First of all, what does your integrity job do?

http://www.sqlpass.org/summit/2015/RegisterNow.aspx

Lynn Pettis (12/23/2014)

---

Okay, I have a question about PASS 2015. I can save a lot of money by registering for PASS 2015 now. My question is when do...

As the Technet article http://technet.microsoft.com/en-us/library/bb510680(v=sql.120).aspx states:

"Sets certain database behaviors to be compatible with the specified version of SQL Server"

It alters how certain aspects of the DB behave, not the structure...