Doug, >Here is a little something that I found. > >http://www.sharewareconnection.com/export-schema-to-sql-for-sql-server.htm
I can copy the entire database w/no problem. The issue is that I need to take our database and create a copy that only contains the records from a specific company. So it's got to be able to analyze the database starting at the table that contains the companies and then figure out how to extract all the users and their data. -Dan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267929 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4