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

• Next in forum: Re: Can anyone help with waittype 0x0044?
• Prev in forum: Re: Add a datestamp to an existing table
• Thread view: Re: What is the purpose of the ROWGUIDCOL property?

[Reply to this message]