Katie, are you making the change because page splitting is an issue with newid, or just like the newer behavior better?

We'll try to validate the link going forward. If you're stilling having issues, drop a note to us via the 'report a problem' link.

Did you consider replication as an option?

One of your better editorials.

It's been quite while since I wrote this, but it may help:

http://www.sqlservercentral.com/columnists/awarren/attachanddetachagain.asp

Travis,

I understand your position, but its just a matter of mitigating the risk isnt it? Aside from that, what do you think could go wrong with this approach?

Maybe we should Steve to sensitivity training? Mind you I dont disagree with his reply, just enjoying the thought of him spending the day getting in touch with his inner...

Egg-head!

I tend to use the mdb over the adp format, just from habit as much as anything. I could entirely be wrong, but doesnt using the ADP format remove the...

The travel part can be challenging. Depending on the location of the event it can be hard to impossible to travel cheaply. Rather than worry about travel, I just look...

I will go back and review all of your comments so far, hopefully in the next few days, and see what I find. As far as ADP's, tuning the queries,...

Glad to do it!

Any chance you have another job/process disabling it?

Thanks for the followup!

Perhaps Win Firewall or ZoneAlarm or similar blocking it? I also ran into this once when I had multiple instances on the box, configured multiple instances to listen to the...