Home Forums SQL Server 2008 SQL Server Newbies Unable to access table in database diagrams. Receive message marked for deleation. RE: Unable to access table in database diagrams. Receive message marked for deleation.

  • 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/