Thanx for the info... If that doesn't settle it, we'll have to open a case with Microsoft .

"Apparently very few people have done much experimentation with 2005 replication."

It's kind of hard to do much replication before the final release is out... replication is more about backing...

Is this a bit column??

Update dbo.Patients Set Billinsurance = 1 where Billinsurance = 0

I'm still 5-10 years away from that.. he just knows too much to be passed on that level. Post count is not a just meter of the knowledge of...

Didn't you read??? You take all our credit so it's normal we don't have any left .

Well I'm out of ideas... not that I had many for this one . I'll keep monitoring this one in case anything...

Where did you get that in books online... This is not listed in mine under set ainsi_padding???

File/connexion?

I mistakenly incorrectly got it almost incorrect. I wanted to pick B because that recovery option doesn't exists. But while validating that C was a correct method I...

Now you also now why we separate the list of items .

On a final note

Told ya you'd get an anser this time .

I thaught I could explain it in my own words but I'm still not sure... maybe you should start another thread for this one as my week-end is about ready...

"Also what is that message supposed to mean? - It's just a quick quote. How many times have you posted a reply to a query, in all its full technical...

IF(SELECT CHARINDEX('JK', 'TRC, JK3, YS, HA')) > 1

print 'alright'

ELSE

print 'oh no'

--"alright" when it should show "oh no" (JK is NOT in the list, bot JK3 is, that's why I added...

No it's shop untill the husband/boyfriend's credit card drops.