sp_upgraddiagrams and SqlMetal RRS feed

  • Question

  • Received this

    Warning : SQM1014: Unable to extract stored procedure 'dbo.sp_upgraddiagrams' fr
    om SqlServer. Invalid object name 'dbo.dtproperties'.

    the trouble is, I cannot find such a stored procedure or such a table dtproperties

    Monday, April 27, 2009 2:22 PM


  • It is a system-generated stored procedure used when you first start the diagram tool on that database from SQL Management Studio.

    If you edit the properties for that connection in SQL Management Studio and switch on the option to show system objects it should appear and you can safely delete it.  If you wish to use diagrams again the tool can recreate it and will hopefully fix the fact that one of the tables it uses seems to be missing.

    • Marked as answer by Mattaniah Monday, April 27, 2009 4:53 PM
    Monday, April 27, 2009 3:47 PM