Home Dashboard Directory Help
Search

Managment studio doesn't know when table is dropped. by Nick F. _


Status: 

Closed


1
0
Sign in
to vote
Type: Bug
ID: 781922
Opened: 3/22/2013 5:02:27 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

Table designer in SQL Server managment studio doesn't recognize when a table is dropped.

Details
Sign in to post a comment.
Posted by Microsoft on 3/25/2013 at 1:41 PM
Hello Nick. We’ve looked into this and found a workaround. When this happens, in order to avoid having to close and lose your saved progress, please take the following steps.
1. Give a default value to all non-null columns
2. Save the table
3. For any non-null columns which you don’t want to have a default value, remove the previously added default value
4. Save the table

Please let us know if this does not work for you.

-Walter A Jokiel, Program Manager, SQL Server (wajokiel@microsoft.com)
Posted by Microsoft on 3/22/2013 at 1:23 PM
Hello Nick. Thank you for bringing this to our attention. We really do appreciate the feedback. We’ll investigate and get back to you. -Walter A Jokiel, Program Manager, SQL Server (wajokiel@microsoft.com)
Sign in to post a workaround.