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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing data type causes error 6
DDL-Adding Autonumber limit 4
File sharing lock count exceeded. Increase MaxLocksPerFile registry 4
file sharing lock count exceeded 3
MaxLocksPerFile (File Sharing lock count exceeded) 1
File sharing lock count exceeded. 1
MaxLocksPerFile Message 0
Lock Count Error 1

Top