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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Replication error

Author  Topic 

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2012-07-26 : 03:07:37
Hi All,

While doing the transactional replication from SQL server 2005 to 2008 i am getting the below error.

Error messages:

Implicit conversion from data type datetime to int is not allowed. Use the CONVERT function to run this query. (Source: MSSQLServer, Error number: 257)
Get help: http://help/257

Initial snapshot has been taken also if we do reinitialize it will go away.

Please kindly suggest.

Thanks,
Gangadhara MS
SQL Developer and DBA

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-07-26 : 13:04:35
Sounds like someone altered the column if you did a snapshot and it goes away with reinitializing it. Compare the two schemas.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -