SQL 2000 and 2005

[Leesha]

Hi,
I use sql server 2005 developer edition. I have a user that has sql server 2000 on their server. They do not wish to upgrade due to cost. If I develope tables in 2005 to work with on my local computer, using Access as to built their database forms etc, will the queries and code that is being used in with sql server 2005 tables be compatable with sql server 2000 tables?

Thanks!
Leesha

[HansV]

If all your queries etc. are in the Access frontend, I don't think you'll have problems.

One thing to watch for: SQL Server 2005 introduced the XML data type, if you have tables with XML fields, they won't be recognized in SQL Server 2000.

[Leesha]

HI Hans,

What great news!! I'm using any XML fields so that should be good!

Thanks!
Alicia

[Wendell]

One word of caution - don't expect to be able to transfer your SQL Server 2005 database to SQL Server 2000 - the formats are not compatible, and there is no conversion support for going backwards. But if you are just concerned about the Qccess side of things, then you should be in good shape. And you can take a backup of a 2000 database and restore it in 2005 - forward conversion works just fine.

[Leesha]

Thanks Wendell! I'll keep these tips in mind.

Leesha