I'm posting this here because I always have trouble finding it when I need it.

SQL Server 2005 ships by default with a utility for exporting objects to T-SQL scripts. Unfortunately, it doesn't allow you to export the data in your tables.

There is, however, a freely available add-on that does this for you – it works just like the wizard that's included out of the box, but the last step asks you if you want schema and data, data only or schema only.

You can get the "Microsoft SQL Server Database Publishing Wizard 1.1" here:

http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en

In order for it to install properly, you will probably also need the "Feature Pack for Microsoft SQL Server 2005 - April 2006" which you can get here:

http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&displaylang=en