Question: how to export table data in sql server 2005?
Answer: Right click on the node in the SSMS object explorer, select Tasks->Export Data and this will invoke the export data wizard. The rest it pretty self-explanatory. After a few times 'next', you can select the tables from which you want to export the structure.