Cannot Script table or open design (Timeout)

hello,

i started having problem 1 database morning in cannot open table in design or right click , "script table as...".  after either of these actions, ssms thinks long time , times out, popping error message shown below. 

this occurring single db, other db's can both of these actions.  other developers having same problem.

i tried restarting service, restarting ssms, nothing seems help.  checked memory in perfmon , there plenty available.  ideas on other troubleshooting steps appreciated!

mark

 

error:

script failed table '<table>'.  (microsoft.sqlserver.smo)

for help, click: http://go.microsoft.com/fwlink?prodname=microsoft+sql+server&prodver=10.50.1600.1+((kj_rtm).100402-1540+)&evtsrc=microsoft.sqlserver.management.smo.exceptiontemplates.failedoperationexceptiontext&evtid=script+table&linkid=20476

------------------------------
additional information:

an exception occurred while executing transact-sql statement or batch. (microsoft.sqlserver.connectioninfo)

------------------------------

timeout expired.  timeout period elapsed prior completion of operation or server not responding. (microsoft sql server, error: -2)

hold fire there.

the object sys.sysobjvalues system table present in every database. 

see: http://msdn.microsoft.com/en-us/library/ms179503.aspx

if want go pocking around, not should unless know playing with, can use dac establish connection user database , review contents of table.

perhaps have success executing dbcc against user database using the repair_allow_data_loss option.

you need manually validate database in suitable , consistent state continue, given data loss may have occurred. providing repair has worked of course.

given dev environment, perhaps source backup production environment?

---

john sansom | sql server dba blog | twitter

SQL Server  >  SQL Server Database Engine