Viewing 15 posts - 2,971 through 2,985 (of 8,416 total)
Gianluca Sartori (7/16/2010)
When some genius coded it that way 10 years ago and switching to identity would mean looking for long lasting trouble.
That would probably be #1 😀
July 16, 2010 at 1:42 am
I should also mention that even if you are running 2005 SP3 CU4 (or 2008 SP1 CU2) onwards, you will need to enable trace flag 845 as a start-up option,...
July 16, 2010 at 12:43 am
Rem-487422 (7/15/2010)
As of now, the user running the SQL process is SYSTEM. Should I apply this policy to this user? Will this be OK?
The Local System account has...
July 16, 2010 at 12:37 am
You might also be interested in voting for this Connect item by Adam Machanic:
July 15, 2010 at 10:43 pm
Paragordius tricuspidatus
(today's random worm)
Haven't done that for a while 🙂
July 15, 2010 at 10:33 pm
Jeff Moden (7/15/2010)
Can you good folks give me an example of when IDENTITY will not work?
When you need a sequence across several tables
When you need to pre-allocate a range of...
July 15, 2010 at 10:30 pm
K Currie (7/15/2010)
yes - that's the case, but I obviously dont want the existing number to change. Please share so I'll know for next time.
Please see the following post...
July 15, 2010 at 10:20 pm
Tom.Thomson (7/15/2010)
July 15, 2010 at 8:45 am
David Burrows (7/15/2010)
Any ideas you have for bumping up membership, I'm all ears.
Yeah, pay for my time off work and the flight across the pond and I'll join.
+1
July 15, 2010 at 7:24 am
Thanks for the encouragement guys 🙂
I will revisit my decision.
July 15, 2010 at 7:23 am
Grant Fritchey (7/15/2010)
I was trying to answer a question not asked.
Then you have saved 'Fraggle' posting a future question - yay!
:laugh:
July 15, 2010 at 7:21 am
Gianluca Sartori (7/15/2010)
...but consider that this solution can lead to very extensive row locks if run inside transactions...
Yes that's one of the things to watch out for, though it's not...
July 15, 2010 at 3:54 am
K Currie (7/14/2010)
I'm trying to alter a table by making an existing column an identity column.
There is a super-quick way if the existing column is currently defined as NOT NULL....
July 15, 2010 at 1:56 am
Fraggle-805517 (7/14/2010)
Paul,That works perfect. Thank you very much. That will solve the problem.
Fraggle.
Good. By the way, I think Grant was thinking of the system view sys.sql_modules which...
July 15, 2010 at 1:17 am
mike 57299 (7/14/2010)
Paul,Do I need to do an explicit Begin Trans / Commit to make sure there is no duplicate sequence #'s?
Mike
Hey Mike,
No - and that's the beauty of...
July 15, 2010 at 12:04 am
Viewing 15 posts - 2,971 through 2,985 (of 8,416 total)