Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Unable to access table in database diagrams. Receive message marked for deleation. Expand / Collapse
Author
Message
Posted Wednesday, December 26, 2012 2:36 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 25, 2013 2:23 PM
Points: 7, Visits: 17
Hi,

I am trying to access a table in the Database Diagrams however when I add it I get a message stating unable to access, marked for delation (pleae see attachment).

How can I access this table and restore it?

Thanks.


  Post Attachments 
Marked for deleation.GIF (4 views, 39.11 KB)
Post #1400379
Posted Wednesday, December 26, 2012 2:42 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:44 AM
Points: 13,093, Visits: 12,574
Did you make changes to the table from the diagram tool? This can cause the table to need to be dropped and recreated behind the scenes. Sometimes the diagram tool will get confused because it really is not a good ddl tool. You can probably just restart SSMS and it should be ok.

Try googling "table is marked for deletion cannot be added" and you will find dozens of people with the same issue.


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1400383
Posted Wednesday, December 26, 2012 2:57 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 25, 2013 2:23 PM
Points: 7, Visits: 17
I may have clicked on delete tables from databases vs remove table from diagram.

I did rebooting SQL Server 2005 and it appears. I did research but I was afraid the table would actually get deleted.

Thanks.
Post #1400388
Posted Wednesday, December 26, 2012 3:00 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:44 AM
Points: 13,093, Visits: 12,574
LastJedi (12/26/2012)
I may have clicked on delete tables from databases vs remove table from diagram.

I did rebooting SQL Server 2005 and it appears. I did research but I was afraid the table would actually get deleted.

Thanks.


Well if you clicked on delete table from database....it gets deleted. The only way you are going to recover it is from a backup.


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1400389
Posted Wednesday, December 26, 2012 3:12 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 25, 2013 2:23 PM
Points: 7, Visits: 17
Weird it still appears I did click from the database diagrams section.
Post #1400393
Posted Wednesday, December 26, 2012 3:15 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:44 AM
Points: 13,093, Visits: 12,574
LastJedi (12/26/2012)
Weird it still appears I did click from the database diagrams section.


Then you probably just removed it from the diagram. When you restarted SSMS did it fix the issue?


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1400394
Posted Wednesday, December 26, 2012 3:20 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 25, 2013 2:23 PM
Points: 7, Visits: 17
Yes sir.

Thanks for your help.

Post #1400396
Posted Wednesday, December 26, 2012 3:28 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:44 AM
Points: 13,093, Visits: 12,574
No problem. Glad that worked for you.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1400398
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse