Hi Sergey,
maybe that was it. Soon after I changed the timeout value to 1500 and it went through in a couple seconds or less.
>Applying such change would require exclusive lock on the table. Maybe it cannot be obtained because some other connection uses the table?
>
>>
>>I am using SSMS to change a field in a table to an identity field. However, when I try to save the change it times out (I have set the timeout to 300 seconds, but that hasn't helped).
>>
>>This is the error:
>>
>>Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
>>
>>This is the table definition:
>>
><snip>
>
>>There are only 1445 records in the table. Any ideas why this change times out?
>>