I'm trying to insert an int column
with identity specification = yes
identity increment and identity seed = 1.
There are about 600,000 records on the database.
Before I try to execute this, I went to tools, options, query execution,
sql server, general and checked to make sure
execution time out was set to 0.
When I execute it, I get a message that warnings were encountered during the
pre-validation process and might reuslt in a failure during save. Then it also
says something about this query will take a long time.
When I click yes it starts execution and after a few minutes
get a message:
Unable to modify table. Timeout expired.
Any help will be greatly appreciated.