Can I write SQL 2000 databases with SQL Server 2005?

Can I write SQL 2000 databases with SQL Server 2005?

• posseke

  http://www.google.co.uk/search hl=en&q=sql+server+2000+developer+edition&meta=
  
  This may be what you're looking for.
  
  SQL Server developer edition sounds as though it will cater for your needs (at home, when developing, this is a non-production environment)
  
  So, you could use all the features of SQL, then transfer it up to your hosted server for the production environment.
  
  From: http://www.microsoft.com/sql/editions/developer/default.mspx
  
  

  Developer Edition allows developers to build and test any type of application on top of SQL Server on 32-bit and x64 platforms. It includes all of the functionality of Enterprise Edition, but is licensed for use as a development and test system, not as a production server. Developer Edition can be upgraded to SQL Server Enterprise Edition for production use.

  
  
  

• Rudedog2

  Steven -
  
  That is EXACTLY what I was looking for. 
  
  Bought it today.
  
  Thank you very much. 
  
  

• Sthrudel

  Thanks very much.  SQL/MSDE seems pretty abstract to me from that standpoint.  I'm used to having an Access database that i can manipulate from the Access application - for example, so I can pull up the records I change in VB and see what damage I might have done.  I'd be pretty hesitant to write a database with scripts and then not be able to see it other than by using other scripts, i.e., basically creating my own application.  Why does SQL Server 2000 cost so much This has really put a crimp in my learning Visual Studio.  The walkthroughs in the book provided are geared toward SQL Server, so i have to adapt the tutorials to Access databases.  Anyway, thanks for responding.
  
  

• GDC2579

  No, you cannot.  What you can do is script your databases (make sure to put them into 8.0 compatibility mode to ensure that you don't use 9.0 features like VARCHAR(MAX)) and use the DDL and DML to populate your shared hosting database.

   

  See:  http://www.karaszi.com/SQLServer/info_generate_script.asp

  
  --
  Adam Machanic
  Pro SQL Server 2005, available now
  http://www..apress.com/book/bookDisplay.html bID=457
  --

   

   

  <sharnish@discussions.microsoft.com> wrote in message news:1175c6b5-bf9f-42d1-b8d2-5368258cf5d9@discussions.microsoft.com...

  My shared hosting service only supports SQL 2000.
  
  Thank you.

  
  
• Can I write SQL 2000 databases with SQL Server 2005?