CODEWITHSUNDEEP
c#sql-serverwinforms
baked
baked

Reputation: 245

SqlException: Invalid column name - Column doesnt exist

I am in the process of moving a database from one server to another. But now I am getting the error 'Invalid column name msrepl_tran_version'. This is a column which I deleted off the new database as it was related to replication which I no longer need.

I have recreated the Datasets, done a search for anything with msrepl_tran_version in the entire solution and nothing. I can't see where it is referencing this column from, it doesn't exist!

Any ideas would be much appreciated.

Thanks.

Upvotes: 0

Views: 1765

Answers (1)

BLoB
BLoB

Reputation: 9725

It is a transactional replication column and not straight forward to remove, it seems you haven't totally removed it...

how to remove msrepltranversion column

Upvotes: 1

Related Questions