Changing field props in SQL Management Studio

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Piasecznik - 14 Mar 2008 10:10 GMT

Hi,

I have average database with something like 15M records. I have to change
some fields property of tables with average 4M records. On smaller tables I
can change one field at time and save design would be successful but on
larger tables I got timeout something like 25 seconds after pressing OK.
Where I can change timeout period or disable it?
Tried to put 0 on Connection window, changed to 0 remote query timeout, but
it does not change anything.

Thanks

Robert

Reply to this Message

Tibor Karaszi - 14 Mar 2008 10:26 GMT

I strongly encourage you to do these changes using ALTER TABLE instead of the GUI since the GUI can
be quite clumsy regarding the SQL it generates.

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

> Hi,
>
[quoted text clipped - 9 lines]
>
> Robert

Reply to this Message