May 1, 2003 at 6:13 pm
Hi,
I have sql server 2000 installed in my machine. I constantly create maintenance work and create scripts which are sent to numerous clients who have only sql server 7.
I am trying my best to make sure i dont include any sql server 2000 specific TSQL/functions. It is sort of difficult.
So i would like to know If i can set sql server 2000 to behave like sql server 7 as and when i wanted so that i can develop scripts and test it as if i am in sql sever 7.
May 1, 2003 at 6:27 pm
Install SQL Server 7.0 as default instance and 2000 as named instance so you can have both environment to develp sctipts for different needs.
May 4, 2003 at 9:51 pm
Hi
Uninstall 2000, install 7 as a default instance, then install 2000 overtop with named instances... all should work a treat. Note that there are some DTS designer issues managing both and I believe (from memory here) that they are only resolved with the latest patch set of the 2000 dbms.
Cheers
Ck
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply