OnlyOneRJ (4/30/2013)
U can only script the Structures of Tables, Stored Procedure, Functions & Views & then run that script on 2000..Regarding data.. just create a DB manually on 2000 same as it was on 2008 & then use Import/ Export Data & transfer the data between both servers.. this is what i know..
Experts are here to guide you more on this (Example - Gail) 🙂
You can script the entire thing including data if you want. Depending on the amount of data this may be unrealistic of course.
Certainly you don't need to create the DB manually. Use the generate scripts feature, make sure you hit the advanced section so you can script all the indexes and such.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/