can't modify table in SMS...timeout expired?

Hi: I'm trying to add a field to a table by modifying it in Management
Studio. I'm running SQLSMS locally on the server.
When I try to save the table I get an error
"Post-Save Notifications...
[table name]
- Unable to modify table.
Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding."
The table currently has 5454 rows in it.
geek-y-guy (noone@.nowhere.org) writes:
> Hi: I'm trying to add a field to a table by modifying it in Management
> Studio. I'm running SQLSMS locally on the server.
That is a very dangerous function, which has serious bugs and shortcomings.
I strongly recommend to use ALTER TABLE statements to change your tables.
Or, at the very least, never, I say NEVER, save directly to implement
a change, but always generate a script and perform these modifications:
o Remove all BEGIN and COMMIT TRANSACTION except for the first and last.
o Wrap all batches in IF @.@.trancount > 0 BEGIN ... END
o Change all WITH NOCHECK to WITH CHECK.
And be very careful to check that the script only include the
changes you want to make. There are bugs that can cause discarded
changes to be includd.

> When I try to save the table I get an error
> "Post-Save Notifications...
> [table name]
> - Unable to modify table.
> Timeout expired. The timeout period elapsed prior to completion of the
> operation or the server is not responding."
> The table currently has 5454 rows in it.
Under Tools->Options there is a timeout for the Designers you can
change, if you insist on using that function. But if you run the script
from a query window,the timeout is not an issue.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Cant get SQL Express Installed

Hi-

I had previously had VS2005 Beta installed from my MSDN discs. When it expired, I uninstalled it and downloaded VWD Express to install. VWD installed fine, but the SQL Server Express will not install. The VWD install package doesn't give me any feedback, just says it failed. I tried dowloading and installing SQL Express separately, and it tells me that I have to uninstall all components from other versions. I have done that, but still wont install. If I use the uninstall utility on the website, it tells me it can't find any components, and all of the components listed in the manual uninstall instructions are missing, so I can't find anything further to uninstall. (FYI: I'm running XP Pro SP2).

I'm wondering if a registry setting or something didn't get updated on uninstall. I see a registry folder for "Microsoft SQL Server" but I do not know if this could be getting in the way.

Any help would be appreciated.

-Moz

I guess the issue is caused by imcompletely uninstalled VS2005 beta components. You can find SQL Server setup logs under the "%ProgramFiles%\Microsoft SQL Server\90\Setup\Bootstrap\LOG\Files" folder. However the logs are always verbose to read. So it may be better to uninstall all existing VS2005 components completely, please refer to this article:

http://msdn.microsoft.com/vstudio/support/uninstall/default.aspx

|||

Yeah, I followed the uninstall instructions, but none of the programs to uninstall are in my list. I looked at the logs (thanx for the lead on that) and it appears that the errors are thrown when it loads the msi.dll. The errors in the log indicate that it's finding incompatible versions of the following:

Microsoft SQL Server 2005 CTP|||

I got this straightened out. Nothing was working, but I stumbled on this:

http://blogs.msdn.com/astebner/archive/2005/10/30/487096.aspx

and the steps and tools he provided did the necessary clean up for me, after which I was able to get the express edition installed.

Thanx for the help!

-Moz