Sounds unusual. A guess would be some problem with authentication/network, but I don't know why. If no better ideas come along I'd suggest a call to PSS. Spend the $250...

Could you live with returning the unknown columns as an xml doc at the end of the main resultset? Let the app handle it?

I think SOA gets both under and over used. Sending email is a great instance where you can build a service that many apps throughout the enterprise, and it encourages...

Restoring can be done, but getting replication back in sync is a lot of work. Far easier - if possible within time constraints - is to just plan on doing...

Im sorry if I didnt say it very well. If you upgrade your server to SQL 2005 you could leave your existing databases in their current compatability level and take...

I said inserted instead of insteadof:-) Sorry about that. You're right, the standard text columns are not available in insert, update, or delete triggers unless they are set up as...

Im not sure about the cost. I would guess pretty similar, but thats just a guess. I'll see if I can find anything that digs into it more. As far...

I dont know that I'd agree with that effort entirely. Definitely if you can upgrade to SQL 2005 the use of the new max types makes things a little more...

That is a great question! And to be honest, I didn't think to test it nor do I know the answer! I suspect the update trigger works fine only because...

Scott, that is interesting. I'll have to think more about the implications before commenting more!

I think it would be useful to put up some mock layouts before making changes, more doable now since you have a team supporting you! I think a general clean...

Not sure I agree. I believe the last time I looked you could set views and stuff to be part of the initial snapshot, but there is no provision in...

And Im jealous, I'll have to plan on working for a better grade employer that will get me RAID10 next time:-)

My current employer tends to be really cheap (oh wait,...

Bah Colin!

I dont disagree (at least too much) that RAID5 imposes a perf hit, but the im my view is IT IS the best bang for the buck. Not everyone...

Now that we know that MS is making decisions based on your editorials we should probably make sure you're fully stocked with a list of improvements that we (the DBA's)...