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 |
|
monty
Posting Yak Master
130 Posts |
 Posted - 2006-11-04 : 08:16:36
|
| Hi All,iam getting an error while setting up transcational replication on one of our server with(sql server 2000+sp4+2187hotfix).on one of the database the error is "Implicit conversion from data type text to nvarchar is not allowed. Use the CONVERT function to run this query"(error no:257)and for the second database the error is "Cannot DROP TABLE 'xxx' because it is being referenced by object 'xxx'"did any one get the same kind of error earlier?please share ur thoughts on this.its me monty |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2006-11-04 : 09:22:20
|
| 1st ....why not replication same formats.....2nd Cannot drop table ....if replication is on you cannot drop table from publisheryou have to move the subscriptions and stop replication then drop tables |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-11-06 : 04:44:09
|
| why do you have constraints on the replicated tables in the subscriber?why are you dropping the tables at the subscribers? when you want to reinitialize, just configure to delete the rows instead of dropping...dropping them will remove the permissions you've appliedHTH--------------------keeping it simple... |
|
|
|
monty
Posting Yak Master
130 Posts |
Posted - 2006-11-10 : 00:06:56
|
| Hi All,"Implicit conversion from data type text to nvarchar is not allowed. Use the CONVERT function to run this query"(error no:257)the reason for this error is due to some trigger problem which can allocate only 4000 characters while converting the datatypes. For this Microsoft suggested us to download a hot fix and install it on Publisher as well as Subscriber boxes by installing this hot fix on both boxes the issue got resolved.and for Cannot DROP TABLE 'xxx' because it is being referenced by object 'xxx'" error we have dropped the view at source and destination and implemented the replication of the database later we have created the view again.its me monty |
|
|
|
|
|
|
Replication Error