Post reply

Table(s) were removed from the diagram.....

  • June 9, 2015 at 7:53 pm

    #309082

    Hi All,

    In last week my database was crashed and some how i managed to restore it back on SQL2K12 but after restoration all the relationships are removed and sql server is showing below message when i open diagram of the database.

    Table(s) were removed from the diagram because privileges were removed to these table(s) or the table(s) were dropped.

    Can anybody tell me that how to get back all the relationships of the tables.

    Adil Mukhtar

  • June 9, 2015 at 11:53 pm

    #1804206

    From what you've written it sounds like orphaned user...

    http://www.fileformat.info/tip/microsoft/sql_orphan_user.htm

  • June 10, 2015 at 1:01 am

    #1804222

    Thanks for reply but still relationships have not been recovered.

    Adil Mukhtar

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply