Sorry for the off-topic post, but I know tons of you use SQL Server and it comes up commonly on this mailing list anyway. I used the SQL Server export function (Data Transformation Service) to move data (and table structure) from one SQL Server database to a blank SQL Server database. Everything looked fine initially, however I have realized that it did not copy over default value. Nor did it copy over seed information. Is this common? Is there a better way to do this (Other than detaching / attaching the database)? Although I haven't verified it yet, I do suspect that I exported the data from a SQL Server 2000 DB into a SQL Server 7 DB. Would I experience the same results if this occurred between to SQL Server 2000 DBs? Jeff Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- Instant ColdFusion 5.0 | ISBN: 0-07-213238-8 Due out 3rd Quarter 2001 -- DotComIt, LLC database driven web data using ColdFusion, Lotus Notes/Domino -- Half of the Alternative Folk Duo called Far Cry Fly http://www.farcryfly.com | http://www.mp3.com/FarCryFly -- I've got the brains, you've got the looks, let's make lots of money ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
