NEWSEQUENTIALID()

I'm trying to modify my default value for GUIDs in DB, currently using newid() for default.

In management studio, click on modify and in the table designer for the default value I entered newsequentialid() and got the following error.

Error validating the default for column "xxxx".

I would like to have my tables that are using guids, have newsequentialid as the default value. When read on this new function it says can only be used with default value, but can't get that to work. Any ideas?

thanks

This is a bug in Management Studio. There are two workarounds

1. Create the table by hand in T-SQL.

2. Use newid, then generate a script, and replace the newid with newsequential.

You can file a bug at http://lab.msdn.microsoft.com/productfeedback/

|||I can set the default value OK in management studio if it is a brand new table. I'm trying to upgrade my tables in my DB to have the default to be newsequentialId(). Is there a problem if there is already data in the tables with now changing from newid() to newsequentialid()|||

Why on earth is this not fixed yet AND there doesn't seem to be any official Microsoft posting or commment regarding this?

Seriously annoying bug.

|||

If we cannot answer a question in the forums in the first month, it generally gets ignored and we do not go back and try to answer it later. Whenever there is a problem with our product, I strongly recommend filing a bug or a suggestion in Microsoft Connect.

SQL Server's portal on Microsoft Connect: http://connect.microsoft.com/SQLServer/

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

NEWSEQUENTIALID()

I'm trying to modify my default value for GUIDs in DB, currently using newid() for default.

In management studio, click on modify and in the table designer for the default value I entered newsequentialid() and got the following error.

Error validating the default for column "xxxx".

I would like to have my tables that are using guids, have newsequentialid as the default value. When read on this new function it says can only be used with default value, but can't get that to work. Any ideas?

thanks

This is a bug in Management Studio. There are two workarounds

1. Create the table by hand in T-SQL.

2. Use newid, then generate a script, and replace the newid with newsequential.

You can file a bug at http://lab.msdn.microsoft.com/productfeedback/

|||I can set the default value OK in management studio if it is a brand new table. I'm trying to upgrade my tables in my DB to have the default to be newsequentialId(). Is there a problem if there is already data in the tables with now changing from newid() to newsequentialid()|||

Why on earth is this not fixed yet AND there doesn't seem to be any official Microsoft posting or commment regarding this?

Seriously annoying bug.

|||

If we cannot answer a question in the forums in the first month, it generally gets ignored and we do not go back and try to answer it later. Whenever there is a problem with our product, I strongly recommend filing a bug or a suggestion in Microsoft Connect.

SQL Server's portal on Microsoft Connect: http://connect.microsoft.com/SQLServer/

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

NEWSEQUENTIALID()

I'm trying to modify my default value for GUIDs in DB, currently using newid() for default.

In management studio, click on modify and in the table designer for the default value I entered newsequentialid() and got the following error.

Error validating the default for column "xxxx".

I would like to have my tables that are using guids, have newsequentialid as the default value. When read on this new function it says can only be used with default value, but can't get that to work. Any ideas?

thanks

This is a bug in Management Studio. There are two workarounds

1. Create the table by hand in T-SQL.

2. Use newid, then generate a script, and replace the newid with newsequential.

You can file a bug at http://lab.msdn.microsoft.com/productfeedback/

|||I can set the default value OK in management studio if it is a brand new table. I'm trying to upgrade my tables in my DB to have the default to be newsequentialId(). Is there a problem if there is already data in the tables with now changing from newid() to newsequentialid()|||

Why on earth is this not fixed yet AND there doesn't seem to be any official Microsoft posting or commment regarding this?

Seriously annoying bug.

|||

If we cannot answer a question in the forums in the first month, it generally gets ignored and we do not go back and try to answer it later. Whenever there is a problem with our product, I strongly recommend filing a bug or a suggestion in Microsoft Connect.

SQL Server's portal on Microsoft Connect: http://connect.microsoft.com/SQLServer/

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

newid() question

when you use newid() is that a new uniqueidentifier for the database or for the table?

I have a changelog that captures newly created users first and gives them a newid, then i want to approve that change and copy the newid generated for that user into the user table. Will I run into duplicate id's that way?The NEWID() function creates aGUID. This number should be, statistically-speaking, unique.

NEWID() Generation Code

hi,
i want the code for newid() in sqlserver 2000 , if anyone knows about it please send me the code.I need it for my customised application . It will be of great help.
Could you explain what exactly you're trying to achieve? I can guarantee you no one will send you the code.|||If your customized application is managed code, Guid.NewGuid() generates a new GUID.

If your app is native, HRESULT CoCreateGUID(GUID *pguid) does the same thing.

NEWID()

Hi,

Can someone explain the generation method of a uniqueidentifier in the NEWID() function ?

This number is generated using identification number of computer network card and an unique number from the CPU clock. (The network card is unique too)|||

Why do you care?

The uniqueidentifier is guaranteed to be a unique hex identifier. It is not sequential and cannot be used for any other purpose than a unique id of an object or record.

|||

Check out the following topics for description on the Win32API that SQL Server uses for NEWID and NEWSEQUENTIALID. The actual algorithm details can be found on the web.

http://msdn2.microsoft.com/en-us/library/aa379205.aspx

http://msdn2.microsoft.com/en-us/library/aa379322.aspx

NewID

Hello,

I use VB.Net and SQL CE 2.0. I'd like to start using UniqueIdentifier fields as my primary keys.

I saw that this would return a NewID value

System.Guid.NewGuid().ToString()

however, it is not supported in Compact Framework. So how can one obtain the next NewId()?

Thank you.

NewGuid() is supported in .NET CF 2.0. You can also have a look at this article: http://msdn2.microsoft.com/en-us/library/aa446557.aspx - Generating GUIDs on the Pocket PC