Error on Alter Table to insert identity (counter)

G

Greg

I am receiving the following message when I try to run a simple alter table:

"File sharing lock count exceeded. Increase MaxLocksPerFile registry entry"

The table I am altering contains about a half million records. Is there a
better way to insert an identity(1,1)? This is what I am trying to execute:

alter table ATB ADD column id counter

Thanks in advance,

Greg
 
Top