More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
How to let merge replication use your own rowguid column?
When you create a merge publication, SQL Server adds a rowguid column to all the underlying tables for uniquely identifying a row across multiple copies of the same table.
If you want to add that column by your own and let SQL Server use it in merge replication, your rowguid column should have the following properties:
- Should be of Uniqueidentifier datatype
- Should have the ROWGUIDCOL property set
- Should not allow NULLs
- Should have a default of newid()
Here is an example:
create table table1
(
i uniqueidentifier rowguidcol not null default newid(),
j int
)
(Continued on next question...)
