sjimmo (9/24/2010)

---

Hugo Kornelis (9/24/2010)

--------------------------------------------------------------------------------

if the table is used in replication, ..., SQL Server requires that a surrogate key with the UNIQUEIDENTIFIER data type is also present in the table.

I cannot speak for FILESTREAM, but in order to replicate a table, there must be a primary key on the table. There is not a requirement for UNIQUEIDENTIFIER.