Here is a script to purge the dt* stuff out of your database (if you desire) as well as the actions that create the dt* objects.
/**********************************************************************************
*
* VSS: START -----------------------------------------------------------------
* VSS: $Workfile: SUPPORT_DROP_DT_OBJECTS.SQL $
* VSS: $Archive: /Projects/FCP2.0/src/SQL/Common Objects/Utilities/SUPPORT_DROP_DT_OBJECTS.SQL $
* VSS: $Author: A217780 $
* VSS: $Date: 4/27/01 9:41a $
* VSS: $Modtime: 4/27/01 9:13a $
* VSS: $Revision: 2 $
* VSS: $Header: /Projects/FCP2.0/src/SQL/Common Objects/Utilities/SUPPORT_DROP_DT_OBJECTS.SQL 2 4/27/01 9:41a A217780 $
* VSS: STOP ------------------------------------------------------------------
*
* DESCRIPTION: This script is used to purge all the dt* stored procedures and tables
* from the current database. The dt* objects get into the database as a result
* of using the 'Databas Diagram' feature of SQL Server Enterpise Manager.
*
* Here are the actions in SQL Server Enterprise Manager which create the dt* objects:
* --> Expand Databases
* --> Expand a target database
* --> Click on Diagrams
* --> Right mouse and click 'New Diagram' (As soon as you do this, the table and
* procedures are added without prompting)
*
*
* MODIFICATION LOG:
*
* Rev. Date Developer Brief Description of Change
* ----- ---------- ------------------- -------------------------------------
* 1 04/24/2001 Brendan H. Sullivan * Initial Version
* 2 04/27/2001 Brendan H. Sullivan * Added a check for existence.
**********************************************************************************/
IF OBJECT_ID('dt_addtosourcecontrol') IS NOT NULL
BEGIN
DROP PROCEDURE dt_addtosourcecontrol
IF OBJECT_ID('dt_addtosourcecontrol') IS NOT NULL
PRINT '<<< FAILED DROPPING PROCEDURE dt_addtosourcecontrol >>>'
ELSE
PRINT '<<< DROPPED PROCEDURE dt_addtosourcecontrol >>>'
END
go
IF OBJECT_ID('dt_adduserobject') IS NOT NULL
BEGIN
DROP PROCEDURE dt_adduserobject
IF OBJECT_ID('dt_adduserobject') IS NOT NULL
PRINT '<<< FAILED DROPPING PROCEDURE dt_adduserobject >>>'
ELSE
PRINT '<<< DROPPED PROCEDURE dt_adduserobject >>>'
END
go
IF OBJECT_ID('dt_adduserobject_vcs') IS NOT NULL
BEGIN
DROP PROCEDURE dt_adduserobject_vcs
IF OBJECT_ID('dt_adduserobject_vcs') IS NOT NULL
PRINT '<<< FAILED DROPPING PROCEDURE dt_adduserobject_vcs >>>'
ELSE
PRINT '<<< DROPPED PROCEDURE dt_adduserobject_vcs >>>'
END
go
IF OBJECT_ID('dt_checkinobject') IS NOT NULL
BEGIN
DROP PROCEDURE dt_checkinobject
IF OBJECT_ID('dt_checkinobject') IS NOT NULL
PRINT '<<< FAILED DROPPING PROCEDURE dt_checkinobject >>>'
ELSE
PRINT '<<< DROPPED PROCEDURE dt_checkinobject >>>'
END
go
IF OBJECT_ID('dt_checkoutobject') IS NOT NULL
BEGIN
DROP PROCEDURE dt_checkoutobject
IF OBJECT_ID('dt_checkoutobject') IS NOT NULL
PRINT '<<< FAILED DROPPING PROCEDURE dt_checkoutobject >>>'
ELSE
PRINT '<<< DROPPED PROCEDURE dt_checkoutobject >>>'
END
go
IF OBJECT_ID('dt_displayoaerror') IS NOT NULL
BEGIN
DROP PROCEDURE dt_displayoaerror
IF OBJECT_ID('dt_displayoaerror') IS NOT NULL
PRINT '<<< FAILED DROPPING PROCEDURE dt_displayoaerror >>>'
ELSE
PRINT '<<< DROPPED PROCEDURE dt_displayoaerror >>>'
END
go
IF OBJECT_ID('dt_droppropertiesbyid') IS NOT NULL
BEGIN
DROP PROCEDURE dt_droppropertiesbyid
IF OBJECT_ID('dt_droppropertiesbyid') IS NOT NULL
PRINT '<<< FAILED DROPPING PROCEDURE dt_droppropertiesbyid >>>'
ELSE
PRINT '<<< DROPPED PROCEDURE dt_droppropertiesbyid >>>'
END
go
IF OBJECT_ID('dt_dropuserobjectbyid') IS NOT NULL
BEGIN
DROP PROCEDURE dt_dropuserobjectbyid
IF OBJECT_ID('dt_dropuserobjectbyid') IS NOT NULL
PRINT '<<< FAILED DROPPING PROCEDURE dt_dropuserobjectbyid >>>'
ELSE
PRINT '<<< DROPPED PROCEDURE dt_dropuserobjectbyid >>>'
END
go
IF OBJECT_ID('dt_getobjwithprop') IS NOT NULL
BEGIN
DROP PROCEDURE dt_getobjwithprop
IF OBJECT_ID('dt_getobjwithprop') IS NOT NULL
PRINT '<<< FAILED DROPPING PROCEDURE dt_getobjwithprop >>>'
ELSE
PRINT '<<< DROPPED PROCEDURE dt_getobjwithprop >>>'
END
go
IF OBJECT_ID('dt_getpropertiesbyid') IS NOT NULL
BEGIN
DROP PROCEDURE dt_getpropertiesbyid
IF OBJECT_ID('dt_getpropertiesbyid') IS NOT NULL
PRINT '<<< FAILED DROPPING PROCEDURE dt_getpropertiesbyid >>>'
ELSE
PRINT '<<< DROPPED PROCEDURE dt_getpropertiesbyid >>>'
END
go
IF OBJECT_ID('dt_getpropertiesbyid_vcs') IS NOT NULL
BEGIN
DROP PROCEDURE dt_getpropertiesbyid_vcs
IF OBJECT_ID('dt_getpropertiesbyid_vcs') IS NOT NULL
PRINT '<<< FAILED DROPPING PROCEDURE dt_getpropertiesbyid_vcs >>>'
ELSE
PRINT '<<< DROPPED PROCEDURE dt_getpropertiesbyid_vcs >>>'
END
go
IF OBJECT_ID('dt_isundersourcecontrol') IS NOT NULL
BEGIN
DROP PROCEDURE dt_isundersourcecontrol
IF OBJECT_ID('dt_isundersourcecontrol') IS NOT NULL
PRINT '<<< FAILED DROPPING PROCEDURE dt_isundersourcecontrol >>>'
ELSE
PRINT '<<< DROPPED PROCEDURE dt_isundersourcecontrol >>>'
END
go
IF OBJECT_ID('dt_removefromsourcecontrol') IS NOT NULL
BEGIN
DROP PROCEDURE dt_removefromsourcecontrol
IF OBJECT_ID('dt_removefromsourcecontrol') IS NOT NULL
PRINT '<<< FAILED DROPPING PROCEDURE dt_removefromsourcecontrol >>>'
ELSE
PRINT '<<< DROPPED PROCEDURE dt_removefromsourcecontrol >>>'
END
go
IF OBJECT_ID('dt_setpropertybyid') IS NOT NULL
BEGIN
DROP PROCEDURE dt_setpropertybyid
IF OBJECT_ID('dt_setpropertybyid') IS NOT NULL
PRINT '<<< FAILED DROPPING PROCEDURE dt_setpropertybyid >>>'
ELSE
PRINT '<<< DROPPED PROCEDURE dt_setpropertybyid >>>'
END
go
IF OBJECT_ID('dt_validateloginparams') IS NOT NULL
BEGIN
DROP PROCEDURE dt_validateloginparams
IF OBJECT_ID('dt_validateloginparams') IS NOT NULL
PRINT '<<< FAILED DROPPING PROCEDURE dt_validateloginparams >>>'
ELSE
PRINT '<<< DROPPED PROCEDURE dt_validateloginparams >>>'
END
go
IF OBJECT_ID('dt_vcsenabled') IS NOT NULL
BEGIN
DROP PROCEDURE dt_vcsenabled
IF OBJECT_ID('dt_vcsenabled') IS NOT NULL
PRINT '<<< FAILED DROPPING PROCEDURE dt_vcsenabled >>>'
ELSE
PRINT '<<< DROPPED PROCEDURE dt_vcsenabled >>>'
END
go
IF OBJECT_ID('dt_verstamp006') IS NOT NULL
BEGIN
DROP PROCEDURE dt_verstamp006
IF OBJECT_ID('dt_verstamp006') IS NOT NULL
PRINT '<<< FAILED DROPPING PROCEDURE dt_verstamp006 >>>'
ELSE
PRINT '<<< DROPPED PROCEDURE dt_verstamp006 >>>'
END
go
IF OBJECT_ID('dt_whocheckedout') IS NOT NULL
BEGIN
DROP PROCEDURE dt_whocheckedout
IF OBJECT_ID('dt_whocheckedout') IS NOT NULL
PRINT '<<< FAILED DROPPING PROCEDURE dt_whocheckedout >>>'
ELSE
PRINT '<<< DROPPED PROCEDURE dt_whocheckedout >>>'
END
go
IF OBJECT_ID('dtproperties') IS NOT NULL
BEGIN
DROP TABLE dtproperties
IF OBJECT_ID('dtproperties') IS NOT NULL
PRINT '<<< FAILED DROPPING TABLE dtproperties >>>'
ELSE
PRINT '<<< DROPPED TABLE dtproperties >>>'
END
go