Using DTS (SQL Server 7.0 SP 2 running on NT 4.0 SP 6) we tried to make a copy of our database to another database as a backup. When finished we examined it and noticed that all of the default values for bit fields had been removed as well as they now allowed nulls, the IsRowGuid fields with newid() had been changed to just uniqueidentifier and a new rowguid field inserted --- ON ALL OF OUR TABLES.

Did we not set something correctly when using the wizard, is there a stored procedure we need to run, any ideas, suggestions, etc. before we use our last MSDN call to Microsoft.