:::: MENU ::::

This database does not have one or more of the support objects required to use database diagramming

  • Apr 13 / 2009
  • 0
Data Modeling and Database Design, Database Diagrams, dbDigger, SSMS tips and tricks

This database does not have one or more of the support objects required to use database diagramming

SQL Srever Management Studio is equipped with a comprehensive solution for working with database diagrams. But whenever diagram folder inside a database is clicked for the first time following dialog is shown
This database does not have one or more of the support objects required to use database diagramming

SSMS error for database diagrams

The option dialog just asks your permissions to create some system stored procedures that are required to work with diagrams in SSMS. These stored procedures are not created by default in new databases. So You may allow SQL Server to create these system stored procedures for your database. The system stored procedures will be created in your database after you allow to do so. Following are system stored procedures that are created for working with SQL Server diagrams

  • sp_upgraddiagrams
  • sp_helpdiagrams
  • sp_helpdiagramdefinition
  • sp_creatediagram
  • sp_renamediagram
  • sp_alterdiagram
  • sp_dropdiagram;

Once these system stored procedures are created you will never be prompted again by SQL Server for creating these for that database.

Consult us to explore the Databases. Contact us