trying to document dmv views for SQL 2005

• Simon_L

  SSCarpal Tunnel

  Points: 4669

  More actions

  January 7, 2009 at 7:38 am

  #129939

  Hi

  after some ideas... Im trying to create a ERD diagram in Embarcadero of the database level DMV views in 2005.. Embarcadero doesnt recgnise them if I attempt to reverse engineer them and nor can I see to get them to appear in a generate scripts option from SSMS ...

  any ideas on to make these views "visible" or how to script them out ?

  the onluy existing resource I can find that models them is the microsoft pdf.. I want something more flexible/user(me) friendly !

  many thanks

  ~simon

• Nicholas Cain

  SSC-Dedicated

  Points: 33009

  More actions

  January 7, 2009 at 8:35 am

  #922585

  You can just open SSMS query window and run a sp_helptext against the view to see the code.

  ---

  
  Shamless self promotion - read my blog http://sirsql.net