What is the usage of RowGUID in sql server?

Question

If a column in a table have uniqueidentifier type, in the "column properties" section in the sql server management studio, a boolean property with name "RowGUID" is exist. all new records that  added to table have a uniqueidentifier, whether rowguid=NO or rowguid=yes. Thus, what is the usage of this field?

Answer 1

Hi,

Please refer then links below,

http://forums.asp.net/t/1248405.aspx

http://stackoverflow.com/questions/4443036/ms-sql-server-row-guid-column

http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/382a076b-8b9b-44a0-b952-28c880102efb

---

Thanks,
Suresh
Please use Mark or Propose as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Answer 2

Only set the RowGuid property to Yes if you are using Replication

---

John

http://knowledgy.org