Posted by Erland Sommarskog on 12/04/07 22:39

Hugo Kornelis (hugo@perFact.REMOVETHIS.info.INVALID) writes:
> The point of setting the ROWGUIDCOL property is to enable you to use
> $ROWGUID instead of the column name in a SELECT list. Frankly, I shudder
> when I attempt to think of scenario's where this would be useful, since
> it implies that you select from a table without knowing yourself what
> column is used for what purpose. <shudder>

It's used a by several features in SQL Server. Merge replication is one.
The new FILESTREAM feature in SQL 2008 also requires the table have a
ROWGUIDCOL.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]