MSDN Blogs

Posts

| |

|

SQL Server SSIS and Replication

How to use 'database snapshot' sync_mode while creating a new Tran/snapshot publication using sp_addpublication

Posted over 5 years ago

by Mangesh Deshpande
- 1 Comments
Writing this blog post to ensure other can try - how to use 'database snapshot' mode of snapshot generation (i.e. @sync_mode parameter value of sp_AddPublication). I am jotting down steps to ensure that when the snapshot agent runs, it will produce the...
SQL Server SSIS and Replication

Altering properties of a Column fails with: Cannot alter column 'column-name' because it is 'REPLICATED'

Posted over 5 years ago

by Mangesh Deshpande
- 0 Comments
Recently had one where Altering column properties or running sp_rename against that column was getting: <error> Caution: Changing any part of an object name could break scripts and stored procedures. Msg 4928, Level 16, State 1, Procedure sp_rename...