-
DTS removes default values
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|