It always annoyed me that there is no way to output schema to a file from SQL 2005 Management Studio. It has the the basic functionality to script out simple objects like table, or database (just the creation of the database itself, nothing in it), but you have to do one object at a time. On top of that, there is no way to output the data into a script ......