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 |
|
Keng Tung
Starting Member
1 Post |
 Posted - 2003-11-17 : 02:08:18
|
| Hi all,I've replicated a database in MS SQL Server 2000 but when I try to copy data (using "Import Data" command) from an exactly similar database from another MS SQL Server, I got the following error:"[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot truncate table 'dbo.RP_ProcessParamSet' because it is published for replication."The source database is not replicated. Is there anyway to do this? Any advice is much appreciated. Thank you in advance.Best regards,KT Lee |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-17 : 12:30:01
|
| You need to drop replication in order to truncate a table. Why use DTS though? You can use linked servers to copy data from one server to the next.Tara |
 |
|
|
|
|
|
Error copying data to replicated tables