April 25, 2006 at 9:47 am
currently our database uses quite a feq guid's with a default value of newid(), I would like to change the default value in management studio for our guids to NEWSEQUENTIALID(). When I try and do this I get an error "error validating default value for column".
April 28, 2006 at 8:00 am
This was removed by the editor as SPAM
May 30, 2006 at 3:56 pm
I just came across this one myself. I imagine that by now you already have a solution, but I'm posting for the benefit of the next person to come across it. You can safely ignore the error. When you get the error dialog, you choose "No". When you try and save the table, you'll get a pre-save validation warning (and you choose Yes to indicate you want to attempt to save). Or you can always use ALTER TABLE.
---------------------------
Microsoft SQL Server Management Studio
---------------------------
Error validating the default for column 'NameGuid'.
Do you want to cancel your changes ?
---------------------------
Yes No Help
---------------------------
May 31, 2006 at 8:04 pm
Katie, are you making the change because page splitting is an issue with newid, or just like the newer behavior better?
June 1, 2006 at 9:15 am
It is the PK on some of our tables and causing lots of fragmentation. Thought this would ease some of that fragmentation by having newsequential() for all inserts. So yes page splitting
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply