none
Mysterious Stored Procedures

    Question

  • SQL Server 2005 sp1

    Maybe you can answer this.

    Are the Stored Procedures dt_CheckOutObject and dt_CheckInObject used for some type of built-in source control?

    Is source control for SQL Server built-in to the Management Studio, or is it purchased separately?

    Thanks!

    Frank

    Tuesday, July 18, 2006 2:53 PM

Answers

  • These are created when you connect using some Visual Tools of Microsoft, this is the list of procedures which will be created during the process:

    dt_addtosourcecontrol
    dt_addtosourcecontrol_u
    dt_adduserobject
    dt_adduserobject_vcs
    dt_checkinobject
    dt_checkinobject_u
    dt_checkoutobject
    dt_checkoutobject_u
    dt_displayoaerror
    dt_displayoaerror_u
    dt_droppropertiesbyid
    dt_dropuserobjectbyid
    dt_generateansiname
    dt_getobjwithprop
    dt_getobjwithprop_u
    dt_getpropertiesbyid
    dt_getpropertiesbyid_u
    dt_getpropertiesbyid_vcs
    dt_getpropertiesbyid_vcs_u
    dt_isundersourcecontrol
    dt_isundersourcecontrol_u
    dt_removefromsourcecontrol
    dt_setpropertybyid
    dt_setpropertybyid_u
    dt_validateloginparams
    dt_validateloginparams_u
    dt_vcsenabled
    dt_verstamp006
    dt_verstamp007
    dt_whocheckedout
    dt_whocheckedout_u
    dtproperties

    HTH, jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---
    Tuesday, July 18, 2006 3:26 PM
    Moderator

All replies

  • These are created when you connect using some Visual Tools of Microsoft, this is the list of procedures which will be created during the process:

    dt_addtosourcecontrol
    dt_addtosourcecontrol_u
    dt_adduserobject
    dt_adduserobject_vcs
    dt_checkinobject
    dt_checkinobject_u
    dt_checkoutobject
    dt_checkoutobject_u
    dt_displayoaerror
    dt_displayoaerror_u
    dt_droppropertiesbyid
    dt_dropuserobjectbyid
    dt_generateansiname
    dt_getobjwithprop
    dt_getobjwithprop_u
    dt_getpropertiesbyid
    dt_getpropertiesbyid_u
    dt_getpropertiesbyid_vcs
    dt_getpropertiesbyid_vcs_u
    dt_isundersourcecontrol
    dt_isundersourcecontrol_u
    dt_removefromsourcecontrol
    dt_setpropertybyid
    dt_setpropertybyid_u
    dt_validateloginparams
    dt_validateloginparams_u
    dt_vcsenabled
    dt_verstamp006
    dt_verstamp007
    dt_whocheckedout
    dt_whocheckedout_u
    dtproperties

    HTH, jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---
    Tuesday, July 18, 2006 3:26 PM
    Moderator
  • Good morning, Jens.

    Can you tell me if we can drop these sp? For example, say, for a clean distribuition of a database, with table-only content?

    Thanks a lot.

    Fernando M.

     

    Wednesday, November 22, 2006 12:32 PM
  • Yes, if you need created database diagrams you should leave the dbpoperties.

    HTH, Jens K. Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---
    Friday, November 24, 2006 7:12 AM
    Moderator
  • Hi,

    Can you please explain me something more on this as why this is gettting created and is it created first time an application bound to a source control, is run. And please explain me as any usage of these procedures as this is piling my number of database procedures.

     

    Thanks

    Sukin

     

    Monday, October 22, 2007 7:49 AM