Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dr223
Constraint Violating Yak Guru
444 Posts |
 Posted - 2009-06-30 : 05:31:15
|
| Hallo, When I try to set a primary key to one of my field, I receive the following error as shown below. Any reason why this might be happening? Thanks'o_pat' table- Unable to modify table. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. |
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-06-30 : 08:56:19
|
| http://support.microsoft.com/?kbid=915849 |
 |
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-06-30 : 08:57:02
|
| This behavior occurs because of the transaction time-out setting for the table designer and for the database designer in SQL Server Management Studio. You can specify this setting in the Transaction time-out after box. By default, this setting is 30 seconds. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-30 : 13:01:00
|
| where you trying to do this from designer or by query? |
|
|
|
|
|
|
Re: error message