December 26, 2012 at 2:36 pm
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.
December 26, 2012 at 2:42 pm
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 Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
December 26, 2012 at 2:57 pm
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.
December 26, 2012 at 3:00 pm
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 Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
December 26, 2012 at 3:12 pm
Weird it still appears I did click from the database diagrams section.
December 26, 2012 at 3:15 pm
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 Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
December 26, 2012 at 3:20 pm
Yes sir.
Thanks for your help.
December 26, 2012 at 3:28 pm
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 Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply