sql-server


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.

Related Links

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

Categories

HOME
arrays
sharepoint
swift
cil
signalr
crate
itext
rotation
webrtc
mapbox-gl-js
jscript
sbt-assembly
hyperledger-fabric
tizen-wearable-sdk
codeblocks
subquery
google-shopping
gatsby
xlsx
store
cross-platform
opera-mini
saiku
google-openid
multicore
excel-2010
deb
iup
explode
searchbar
data-cleansing
java-ee-7
visual-c++-2017
ui5
pptp
multichoiceitems
dhtmlx-scheduler
red-black-tree
twitter-bootstrap-2
protobuf-net
ipfw
edb
large-data
hashcat
shibboleth
haskell-pipes
agent
polyfills
ddms
tripwire
knockout-3.0
bing-translator-api
median
facebook-chatbot
3scale
appstore-approval
istorage
azureportal
scd
quintus
typhoon
alter
update-site
mix
tomcat5
pax-web
multiple-file-upload
soda
mpeg-4
fill
asp.net-mvc-2
handlebars.java
spservices
test-class
qbfc
integral
stream-framework
rx-groovy
harp
adodb
jython-2.7
proximity
omnifocus
power-law
bsp
coin-flipping
neoload
mbox
unison
bfd
layered
asp.net-mvc-scaffolding
sql-server-2012-web
iconv
phpsh
blockingqueue
couchdb-lucene
objective-c-protocol
datamember
printing-web-page
pivotal-crm
mvccontrib-grid
task-management
boost-date-time
odbc-sql-server-driver

Resources

Mobile Apps Dev
Database Users
javascript
java
csharp
php
android
MS Developer
developer works
python
ios
c
html
jquery
RDBMS discuss
Cloud Virtualization
Database Dev&Adm
javascript
java
csharp
php
python
android
jquery
ruby
ios
html
Mobile App
Mobile App
Mobile App