I've been using BACKUP and RESTORE scripts to replicate BDs to new DBs for years and would like to move to using CREATE and INSERT instead.
Is there a stored procedure that will create a full set of CREATE and INSERT statements to completely create a new DB? If there's something in the Management Studio I'm just not finding it. I've tried "Script Database As... Create To... Clipboard" but this only creates the table structure and doesn't include the data. I am using SQL Server Express. Thanks, Mik ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301934 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
