SQL 2005

There are 2 entries for the tag SQL 2005

Convert SQL 2005 to SQL 2000 Part II

In response to my previous post, I have just spotted the new "Publish to Provider" option in VS2008 server explorer.  It builds a script to recreate the db together with the data, and has an option to target 2000 – pretty easy solution all round... Cheers Ian Technorati Tags: SQL 2005,SQL 2000

Convert SQL 2005 db to SQL 2000

Technorati Tags: SQL 2005,SQL 2000 I recently had to do this, and had to scratch my head a bit. Anyway here is the path I took I created an empty db in sql 2000 Generated a create db script for the sql 2005 db using management studio (Right click on DB > Tasks > Generate Script), including all objects in the selected db.  There is also an option in this wizard: Script for Server version, which I set to SQL 2000  Ran the script on the...

«September»
SunMonTueWedThuFriSat
2930311234
567891011
12131415161718
19202122232425
262728293012
3456789