Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mssql2004
Starting Member
1 Post |
 Posted - 2004-03-01 : 12:14:46
|
| I am attempting to dts a range of tables from one DB to another, however, the database contains a default contraint, when I run the dts it fails with the following error:The default 'GPS_CHAR' cannot be dropped because it is bound to one or more column.Any idea on how to get around this? Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-01 : 12:57:25
|
| If you are just moving tables from one SQL Server to another, then I would avoid DTS for this. Just use T-SQL. Script out the tables, then transfer the data using INSERT INTO with a linked server.But if you must use DTS, then unbind your column prior to the transfer.Tara |
 |
|
|
|
|
|
Table import