May 15, 2003 at 2:39 am
I have converted my access database to SQL and all seemed to be working fine until I went to add new fields to one of the tables. When I go to save the changes, I get the hour glass that never goes away (i.e. Enterprise Manager hangs).
I can add the same fields to any other table without any problems so does this mean that the table I am trying to update is corrupted?
Any help would be greatly appreciated.
May 15, 2003 at 2:45 am
Hi,
can you provide more information on what you are doing? What are you trying to add. How many records are in the table? ...
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 15, 2003 at 4:15 am
Do you have the table open somewhere else? If SQL needs exclusive access to make the change, it'll sit there until it gets it.
Andy
May 15, 2003 at 6:44 pm
Two questions:
1) Are you adding the columns to the end of the table or are you inserting them in between other columns?
2) Is this table referenced by another table (foreign key)?
The reason I am asking is that SQL Enterprise Manager will actually rebuild the table if you insert columns anywhere other than at the end of the table. If the table is involved in a foreign key constraint, EM may or may not succeed in rebuilding the table.
Just a thought...
David R Buckingham, MCDBA,MCSA,MCP
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply