>Hi,
>
>I have a table with 1000000 records i try to add a field with following`spec.
>
>[mkey] [int] IDENTITY(1,1) NOT NULL
>
>I get the following meassage:-
>
>yearly' table
>- Saving Definition Changes to tables with large amounts of data could take a considerable amount of time. While changes are being saved, table data will not be accessible.
>
>Then I Have the following error:-
>Time out error
>
> regards

You should be able to do this from SQL Server Management console without timeout problems.

If you need to, look at ..

This link

to see how to change the timeout setting for remote queries.