Adding merge replication changed datetime fields to Datetime2(7)
we added merge replication to our SQL 2008 DB and it changed all our datetime fields to datetime2(7), and MS Access 2010 sees it as a text field. which breaks everything. WTF WTF WTF. and if I try to change data type back to Datetime, it wont let me. SQL Server was a good product until SQL 2005, then it started turning into a complicated pile of crap. searching MS support articles is also a lost cause.
Hi, I just read through the comments here and am a little surprised that the date column is being changed. That certainly isn't what should happen! That being said, your issue is probably more to do with how SSMS was coded/designed rather than SQL server itself. SSMS is terrible when it comes to table schema changes, it basically copies the old table into a new one with the new schema and drops the old table. This doesn't work with a replicated table as you could imagine. I would suggest you look at making your desired changes using T-SQL in SSMS. That way you know what commands are being sent to SQL Server. Could you give that a try and get back to us?