Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002
    Toronto, Canada

    Unanswered: Mistakenly removed dtproperties, now I can find my diagram

    I am currently testing SQL Server 2000 Evaluation version.

    I created a diagram with the diagraming tool, but in the process I mistakenly deleted the system table 'dtproperties'. I have a backup of the database, but the last time I restored it, I lost my diagram (and had to do it again)

    What I've done to try to get it back:
    I have another database with the old table schema, and I tried to enter all the values it that old database's dtproperties into the recent db's dtproperties, but that didnt' work especially since I didn't know how to copy the lvalue column.

    How can I restore my diagram?

  2. #2
    Join Date
    Aug 2002
    I believe no chance to retrieve the diagram as you're using EEE.
    --Satya SKJ
    Microsoft SQL Server MVP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts