Cannot convert SQL Server 2005 Database to SQL Server 2000

Hi all,
can anybody tell how to use sql server 2005 database in sql server 2000? i thought it will work easily but its ont working. do i need conversion? Please help me.

hi you cant use a 2005 database in 2000 server

this is not possible in any way

|||One workaround is to setup a snapshot replication.|||

You could use "Import and Export Wizard" to copy Tables and views and data to target SQL 2000 server.

Using Management Studio, connect to SQL 2005 Server and Right click on database and select Tasks -> Export Data

If any of your table leverages new functionality in SQL 2005, you cannot copy those tables

You could use Generate Scripts Wizard to script functions and stored procs. As long as they dont use new SQL 2005 features , you could apply those scripts on target SQL 2000 Server

Thanks

Sethu Srinivasan

SQL Server Manageability Dev Team

|||You can use this.

http://sql-articles.com/index.php?page=articles/migrating_2005_2000.html

Hope This Helps