We have a database that is replicated. We had network problems the other day and I had to reinitialize the replication. Now I notice that there is a rowguide column in the table that is being replicated. Does anyone know what this is or where is came from and can I just remove it from the table?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
rowguid column
- Thread starter cocopud
- Start date
mrdenny
Programmer
- May 27, 2002
- 11,595
It can not be removed. With replication in SQL 2000 and below, replication adds the additional rowguid column to the table. It uses that column as a secondary primary key of sorts.
The replication uses that column to find the records that need to be updated or deleted.
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
The replication uses that column to find the records that need to be updated or deleted.
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question