In managment studio of SQL server 2005 I often get the following error:

Unable to modify table.
Timeout expired.  The timeout period elapsed prior to completion of the
operation or the server is not responding.

On the other hand in sql enterprise manager(sql2000) the same things works.

Is there some setting in SQL2005 for timeouts or something similar?

Regards,S

Have you tried running an ALTER TABLE statement instead of pointing and
clicking in a GUI?

A

Creating alter table statement each time when I wan't to change something is
time consuming.

I rather go to the old good enterprise manager :)

There are also some other things I don't like in new user interface(ok, some
of new features are great, I don't won't to criticize), but I think, that at
least the new SQL server managment studio
should work with basic things, like alter table is. I had also problems with
connecting to some remote servers. I couldn't  see the definition of views
and functions, I get some strange errors like:
"Script failed for UserDefinedFunction 'dbo.s_getin'
PropertyQuotedIdentifierStatus is not available....."and so on.

While on the other hand with enterprise manager 2000 everything works.
Any idea?

regards,Simon

Show quoteHide quote

smalldatetime or integer
Activity Monitor
Problem with SET QUOTED_IDENTIFIER ON
Service Broker - The right approach?
Theory on composit key