SQL Server 2008 timeout when adding new column
Posted on 2012-08-31
I am trying to add a column to any table in my DB but it is takes longer than expected. The total DB size is 16mb. I have tried through Management Studio and it times-out with error below. I know you can increase the timeout threshold within Management Studio but have not done so yet because I tried the route of TSQL "Alter Table tablename ADD columnname int". This takes beyond 10 minutes which does not seem right to me. I understand the general process of adding a new column behind the scenes and the small size of my tables which leads me to think there is a larger problem and this is a symptom.
The error I receive from MSSMS is:
- Unable to modify table.
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.