Thanks for this advice guys, I ended up Detaching the database and sending a copy of the files to them for reattaching, this worked fine for the moment as it takes across data as well as structure. Nice to know those scripting methods though.
Thanks, Rob -----Original Message----- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: 29 May 2007 20:40 To: SQL Subject: Re: Backup Robert Rawlins - Think Blue wrote: > > I'm looking for some help on a rather complex query issues, but it involves > a stack of tables and a lot of joining and I'm struggling to find anyone > that is able to help with the explanations I'm able to give, so, I'm looking > to create a small 'backup' of the database, that I can then post for > download, other devs can then simply import the database and they have a > working model to play with. >From MSSMSE click your database and select Tables in the left panel. In the right panel select all your tables and right click, Script Tablee As -> CREATE To -> File and post the file online. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2853 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
