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.

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