November 12, 2008 at 9:44 am
This may be really obvious but, I am going hoping to run both SQL Server 2000 and 2005 client tools on my machine.
Are there any installation issues compatiblity issues I should be aware of?
I am aware that there is backward compatability with SQL 2000 within 2005 client tools but I am totally new to 2005 so not sure quite what this means.
Any help would be most appreciated.
November 12, 2008 at 9:57 am
Have installed both (Express versions) without any obvious problems. I Use Query Analyzer for 2000 work and SQL Server Management Studio (SSMS) for 2005, although SSMS can be used for either. Major changes to get used to are the new DM views available in 2005, but most system objects remain for backward compatibility although their use in new work is discouraged since they are dropped in 2008. Many new features available in 2005 that are not available in 2000 and sometimes this can be confusing. Remember a 2000 database once installed on 2005 can not then be installed back to 2000.
Also check in BOL the compatability level .. and its effect on stored procedures and DTS.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply