Rights to view database diagrams in SQL Server 2000

• W R

  SSC-Addicted

  Points: 463

  More actions

  October 26, 2006 at 12:54 pm

  #170259

  I was wondering what rights need to be assigned to view the database diagrams on SQL Server 2000

  Thanks much.

  -Jay

• mdaniel

  SSCarpal Tunnel

  Points: 4616

  More actions

  October 26, 2006 at 5:01 pm

  #668386

  You need to give access to dtproperties table and to all stored procedure that starts with dt_.