SQL Server 2008 Replication Issue
We have a column that was added to the primary database and is being replicated to a secondary database. We are now receiving the following error: Column names in each table must be unique. Column name 'RI_SystemType' in table 'dbo.R_Information' is specified more than once. (Source: MSSQLServer, Error number: 2705) Get help: http://help/2705 Replication is currently failing across the database and we assume that this is the cause. Any suggestions?
Ok, rookie mistake. A deployment script also created the new column in the subscriber. Of course, that's the whole point of replication so once we dropped the column from the subscriber, replication created it itself and all was well.
C# SQL connection string best practice
SQL Server combine rows into single column
Sum monthly amount and output for last day of month
SSRS referring to Database Project in the solution
Error when trying to execute stored procedure
Get actual database size in SQL Server 2012 in GB?
Simple results list from SQL Server stored procedure using Codefluent
SQL Report Error - [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name
How to get distinct column in SQL Server?
Powershell returns negative exit code while script results are correct
Spark program cannot open SQL Server context?
Sql server error 916 when using a trigger that selects data in other database (outside sql server only)
Convert rows from a NoSQL schema to columns in SQL Server
Unable to pass a variable value to a stored procedure in ssis
Getting value of one column ( price ) for max of another column (date) for a set of columns (make.model)
SQL Server 2014 Transaction Log Backup on AlwaysOn High Availability Group