title: convert sql server 2008 database to sql server 2005
body: <p>Hi I have done this before but cannot find out how i did it. I have a website that has a sql server 2008 db which needs to be put on a sql server 2005. i remember scripting it down to recreated it in 2005 i thought i did it through the 'generate script' wizard but this didnt script down the data, just the tables and stored procedures. what would be the best way of doing this? </p>