Developing Matt

My Technical Journal

Proud parent of 32 orphaned dt_ procedures

leave a comment »

Have you ever seen these?  They mysteriously popped up one afternoon on a newly moved database (to 2008).  I knew they didn’t belong, so I deleted them (and one table named dtproperties or something like that).  By the end of the next day they showed up again.  strange. 

A little digging around led to some posts where people said it had something to do with the database diagramming software in ssms (if you use the diagrams in 2005 or 2008 it automatically creates constraints, indexes…and supposedly some procedures), but I didn’t have any diagrams. 

I dropped them and a little later that afternoon they showed up again….all cute and giggly.

It wasn’t affecting anything, there wasn’t any data and there were no problems with these newly adopted objects hanging around mother database.  The lazy in me was tempted to let them play. 

But after digging around a but more I found a lonely soul who had an adp database.  Access has this file variety called ADP (Access 2003…It is discontinued in 2007).  Apparently, it is an intimate tie to the sql server backend.  If you create something in this adp access file it creates it in the back-end.  This seemed like the right road to travel to find the home of these orphaned procedures.  And sure enough, there it was.  All you have to do is click ‘database diagrams’ and viola….a script throws up 32 procedures and a supporting table.  There weren’t any diagrams drawn and the user was innocently clicking the different buttons on the left (tables, queries, diagrams, forms, reports).  That’s it.  That’s all you need to do to find yourself a proud parent of these cute little guys:

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

Advertisements

Written by matt

September 1, 2009 at 8:42 am

Posted in Sql Server

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: