Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Express

Database conversion from SQL Server 2005 to 2000 is not working

hello friends,
i am facing a problem in SQL Server 2005 Express Edition. The database created in the SQL Server 2005 Express is when opened in SQL Server 2000, it changes the data type of all the columns of all the table to text type. can anybody help me?
[260 byte] By [Prashantlakhlani] at [2007-12-22]
«« Build on specific labels
»» How can I connect to the Team Foundation server?
# 1

hi,

you can not attach SQL Server 2005 database to SQL Server 2000 instances... they are not compatible...

regards

AndreaMontanari at 2007-8-30 > top of Msdn Tech,SQL Server,SQL Server Express...
# 2
Hi. Thanks for the Suggesion.
i need to use sql server 2005 database in SQL Server 2000. Is there any other way?
Prashantlakhlani at 2007-8-30 > top of Msdn Tech,SQL Server,SQL Server Express...
# 3

hi,

no... but you can install a SQL Server 2005 instance (even SQLExpress) side by side..

AndreaMontanari at 2007-8-30 > top of Msdn Tech,SQL Server,SQL Server Express...
SQL Server
SQL Server Express

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified