Post reply

Stor Proc dt_xx ... What are these ??

  • April 6, 2005 at 1:18 pm

    #165065

    Hi,

    MSSQL 2000/SP3; Enterprise Manager

    I've noticed that there are stored procs (approx 30), beginning with dt_xx. They are defined as "user" not "system". On some db servers, they exist in the model database, and on other db servers, they don'y exist. I understand why newly created databases inherit these and other databases do not, but what are these? Are they needed? What permissions are required to use them? Can I remove them from the model db? I also heard that they get created dynamically?

    Example: dt_checkoutobject; dt_getobjwithprop; dt_setpropertybyid; dt_whocheckedout_u ... etc

     

    Many thanks. Jeff

  • April 6, 2005 at 1:56 pm

    #550944

    I should know this...  SourceSafe????

    Steve

  • April 7, 2005 at 12:56 am

    #551039

    They are used by the diagram editor in EM.

    --
    Chris Hedgate http://www.hedgate.net/
    Contributor to the Best of SQL Server Central volumes
    Articles: http://www.sqlservercentral.com/columnists/chedgate/

  • April 7, 2005 at 12:13 pm

    #551260

    yup. Database Diagram Editor. If I remember correctly they do not exist in the database when it is created. The are created "auto-magically" when you first launch the Database Diagram Editor.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply