CODEWITHSUNDEEP
sql-serversql-server-2008t-sqlalter-table
Our Man in Bananas
Our Man in Bananas

Reputation: 5977

Error when adding a column with ALTER TABLE on an existing table

We are getting this error when trying to execute an ALTER TABLE command on an existing table:

Msg 208, Level 16, State 1, Procedure sp_MStran_altertable, Line 1071
Invalid object name 'systranschemas'.

The alter table statement is:

alter table dbo.YARPF 
add YARSCWO char(3)

We have admin rights on the SQL server and database.

What can we do to track down and resolve this error?

Upvotes: 0

Views: 988

Answers (1)

DavidG
DavidG

Reputation: 119186

The sp_MStran_altertable procedure is called whenever an object is altered in a replicated database. You are getting the error because replication was partially removed.

You need to manually remove all references to replication. Technet has a good article on how to do this: http://technet.microsoft.com/en-us/library/ms152757(v=sql.105).aspx

Upvotes: 1

Related Questions