Hi,
Thank you for your response. I had already got to the solution between your first and last post.. mainly because of you mentioning the GUI, I insta knew...

Yes I did!

Hi

If @strBoolean = 1 BEGIN

Print 'True'

End else begin

If @strBoolean= 0 BEGIN

Print 'False'

...

Sean Lange (2/5/2013)

---

Antony Symonds (2/5/2013)

---

Is dynamic SQL bad in general or just when it opens up this sort of a security hole allowing for the SQL to fully specified...

Ps that document you linked is absolutely immense... Added to my briefcase...

Yeah that was what was in the example I had found on it... 2gb is about fine for the size....

I am able to make a full backup prior to this...

Thanks Gila,

This was as I suspected and is great news for my situation...

Would you consider my solution a sound solution to the scenario I am in..? I am currently trying...

Is dynamic SQL bad in general or just when it opens up this sort of a security hole allowing for the SQL to fully specified or at least the...

Hey,

Thanks loads for your help with this.

I took the script that table diff created. I ran it at the Subscriber to insert the missing records..

...and Replication....

Did not complain or...

Would seem I had an empty guid that i never used.. and I can get round that no problem... but I have hit another snag 🙁

When I try and insert...

Thank you mate for that info.. i took the lpunge and ran the insert and ... sadly i got this error

Conversion failed when converting from a character string to uniqueidentifier.

So...

MysteryJimbo (8/15/2012)

---

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...

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 cause a...

Oh and thank you for replying earlier appreciate your time 🙂

Yeah everything points to a problem with connectivity between the two SQL servers.. I just need to prove that now!!

They are across VPN's where traditionally the speed hasnt been an...