(newsequentialid())  vs. (newid())

Posted on 2007-07-26
Last Modified: 2008-01-09
Having used the upsizing wizard to move my Access2003 Jet-synchronized DB to SQL 2005 I find the rowguid-field with (newsequentialid()) as Default-Value.
Editing tables is not possible as SQL 2005 pops the error 'Error validating the default for column 'rowguid''
Can I change (newsequentialid()) to (newid()) without any other side effects??
I need to publish the db for merge replication.
Question by:chriswies
    LVL 14

    Accepted Solution

    AFAIK, the reason for introducing sequential guids was to address performance problems that many faced when using non sequential guids generated with newid().

    Some info here

    Author Comment

    Interesting, thanks. One guy there also experiences the validating problem.
    Now, working with replication I do not have to use newsequetialid(). Is that right? What I learned from the link is that newsequetialid() might be a good idea only for high I/O scenarios.
    Did I get that right? What is your conclusion?
    LVL 14

    Expert Comment

    Yeah, looks that way.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now