Only on the server: Updating columns with the rowguidcol property is not allowed
Posted on 2005-03-09
I have a SP, shich uses something like this:
SET ObjectID = ObjectID
I use the SET line just to force a check constraint on this column to be recalculated. The ObjectID column is of type uniqueidentifier, rowguid.
The SP works without any problems on my development machine (Windows XP Pro, SQL Server Personal SP 3, English) but fails with the error "Updating columns with the rowguidcol property is not allowed" on the server (Windows 2003 Server, SQL Server Enterprise SP3, German).
Is this an option or something? Why is it working on my machine and fails on the server?