?
Solved

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

Posted on 2007-07-26
3
Medium Priority
?
1,129 Views
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.
Chris
0
Comment
Question by:chriswies
  • 2
3 Comments
 
LVL 14

Accepted Solution

by:
twoboats earned 1000 total points
ID: 19577558
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

http://blogs.msdn.com/sqlprogrammability/archive/2006/03/23/559061.aspx
0
 

Author Comment

by:chriswies
ID: 19580422
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?
Chris
0
 
LVL 14

Expert Comment

by:twoboats
ID: 19580487
Yeah, looks that way.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

616 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