Pete do you have enterprise manager access to your SQL server ? If so you can probalby use a script like the old sp_scriptsql7db.sql This script generates a database creation script for a 7.0 database - including files, filegroups, default filegroup and database options
Not tried it on a sql2000 or looked to see if there is one like it but it might be a place to start . ____________________________ Paul Fennell Macromedia Certified Advanced ColdFusion Developer Satachi Internet Development Unit 2 7a Plough Yard London EC2A 3LP Tel: 0870 787 3610 Tech Support: 0906 960 7800 Fax: 0709 221 2636 www.satachi.com _____________________________ -----Original Message----- From: Peter Harrison [mailto:[EMAIL PROTECTED]] Sent: 19 September 2002 10:25 To: Dev@Lists. Cfdeveloper. Co. Uk Subject: [ cf-dev ] (slightly OT) extracting SQL data as INSERT script Hi all Anyone know how I can extract all the DATA from my SQL Server 2000 user tables as one big SQL "INSERT" script? Bear in mind tables are related to eachother, etc. Saving the database structure as a script is no problem, as is exporting single tables. This is not what I am after. Is there a piece of software that can do what I need? Thanks. - Peter H. -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
