> > What's the best way to achieve this on SQL Sever 2005? > I'm a fan of the scripting capabilities in Aqua Data Studio...there is a free trial, so you could try it out for this purpose. It produces a file with the DDL for recreating whatever tables you want and produces SQL to insert the existing data into those tables. Then you have a text file that you could zip up and post. I believe the SQL Management Studio will only script the DDL.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2851 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
