For xml was added in SQL2K. I know there was a web release that added some xml functionality to SQL7 but honestly have not looked - that might be a...

That is so pessimistic. I bet you do backups in case the server crashes too.

Andy

Steve's right, should work in both though I don't have a SQL7 install to test on. It will fail if the login is already in the db as a user....

That is SO wrong Steve. Dumb maybe, but not slow!

Andy

Replication is often a good solution for reporting. It's pretty solid these days and relatively low overhead.

Andy

Cant believe you ain't tried it! I'm curious to hear your thoughts once you do. Intellisense in QA would definitely be a productivy enhancer. Both tools are useful, I believe...

No problem at all. Definitely let us know what the resolution turns out to be, Im sure you wont be the only one to have the same issue!

Andy

Functional is good! Figured I'd use the DMO code for something later anyway, so not entirely wasted effort.

Andy

One would be snapshot it to another db, then script out what you need. In SQL2K it's easier, use sp_scriptpublicationcustomprocs.

Andy

I've done point in time several times using EM with no problem, maybe just lucky?

Andy

No, it just writes the definition to a text file.

Andy

I think your best bet is to look at CF resources, maybe their site or a newsgroup. I use OLEDB regularly from VB/VBS without issue, so I would guess that...

Have you got a .dmp file and a copy of the error log we can look at? SP2 just released, you might consider installing it to see if it fixes...

Did you update stats before or after changing the compatibility level? SQL2K should NOT be slower than 6.5.

Andy

Steve, not sure Im totally convinced either. Wouldn't combining EM with a compare tool like the one Red-Gate makes give you the best of both worlds?

I see a lot of...