"Alex via SQLMonster.com" <no@spam.pls> wrote in message
news:6bd9f60658969@uwe...
> Or can I at least use newsequentialid() instead of newid() as the ROWGUID
> default?
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-replication/200701/1
>

AlterEgo wrote:
>Alex,
>
>Yes,
>
>CREATE TABLE dbo.Table1
> (
> test uniqueidentifier NOT NULL ROWGUIDCOL
> ) ON [PRIMARY]
>
>ALTER TABLE dbo.Table1 ADD CONSTRAINT
> DF_Table1_test DEFAULT (newid()) FOR test
>
>-- Bill
>
>> Or can I at least use newsequentialid() instead of newid() as the ROWGUID
>> default?

"Alex via SQLMonster.com" <no@spam.pls> wrote in message
news:6bdbb5cd98e57@uwe...
> Thank you for your response. It seems your code is still using newid(),
> but
> anyway it is not what I was asking. The MS documentation says that one can
> create replication ROWGUID column manually as long as it have the
> following
> characteristics:
>
> * The data type as UNIQUEIDENTIFIER.
> * The default as NEWID().
> * The ROWGUIDCOL property.
> * A unique index on the column.
>
> My questions are:
> 1. Can I use newsequentialid() instead of newid() ?
> 2. Can I supply GUID from my client code instead of using this default
> value?
>
> I am interested in transactional replication model with updating
> subscribers.
>
>
> AlterEgo wrote:
>>Alex,
>>
>>Yes,
>>
>>CREATE TABLE dbo.Table1
>> (
>> test uniqueidentifier NOT NULL ROWGUIDCOL
>> ) ON [PRIMARY]
>>
>>ALTER TABLE dbo.Table1 ADD CONSTRAINT
>> DF_Table1_test DEFAULT (newid()) FOR test
>>
>>-- Bill
>>
>>> Or can I at least use newsequentialid() instead of newid() as the
>>> ROWGUID
>>> default?
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-replication/200701/1
>

"Alex via SQLMonster.com" <no@spam.pls> wrote in message
news:6befae3a28560@uwe...
> What about the following thread then? Is it just SQL CE specific or same
> will
> be true for SQL Server 2005?
> http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-ce/505
>
> I still cannot understand the reason why MS added the second requirement
> (newid() as default for ROWGUID) in this MSDN article:
> http://msdn2.microsoft.com/en-us/library/aa237151(sql.80).aspx
>
> --
> Message posted via http://www.sqlmonster.com
>

"Alex via SQLMonster.com" <no@spam.pls> wrote in message
news:6befae3a28560@uwe...
> What about the following thread then? Is it just SQL CE specific or same
> will
> be true for SQL Server 2005?
> http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-ce/505
>
> I still cannot understand the reason why MS added the second requirement
> (newid() as default for ROWGUID) in this MSDN article:
> http://msdn2.microsoft.com/en-us/library/aa237151(sql.80).aspx
>
> --
> Message posted via http://www.sqlmonster.com
>