Very well put, Hugo!

Hello,

First: I think it is a hard job to detach/attach master database 🙂

Second: it is a final 'no' in not beeing able to run the 2k version? 2k has a...

You should avoid "UPDATE p SET p.name = (SELECT m.name FROM tab2 m WHERE m.number = p.number);" since it will update SOME p.name to NULL: the ones for which there is no...

Hello,

I don't know an answer strict to your question. I had myself, months ago, problems with upgrading from 6.5 to 2000. And I found that wery few were 'in my...

Thank you all for sharing your expertise!

I investigate the topic since I have few sp returning record sets, procedures that use up to 3  temp tables to perform some statistics....

Hello!

I tested also with 'alter' command. It works if you not use 'on update/delete cascade' (it enforces the constraints), so I think you could 'cascade' (propagate) the appropriate changes  trough a...

Hello!

INHO I think there are more issues to care for, like security and 'what you care fore most' (website or db). Licensing is not a problem since you are allowed to...

Thank you Yelena!

My silence was the result of following your advice about SQLserver 7.

In the process I discovered the 'mother of all evil': I installed a named instance...

Hello Yelena,

Very kind of you, I just hope that you receive same kind of responsiveness when you need it!

I have a CD with the update wizard, although the 'Update...

Thank you, I really appreciate your support!

The version, as installed, is 8.00.194. The source of all evil is the installation kit, which lacks the 'Upgrade Tools' as a sub-component...