6.2 Compare is errantly flagging source control procs(dt_)

• 
  Hi DK,
  
  Is it possible that the dt_ set of stored procedures are 'system'-type objects? SQL Compare ignores all objects that are part of a database's system schema, for instance metadata (syscomments, sysobjects, etc). If the source control tables are marked as system in one database and not in the other, they would appear as missing objects.
  
  Hope this helps!

  Brian Donahue December 14, 2007 09:04

  - 0 +
• 
  Jumping in on an old post here but i thought i would let people know that indeed this is the problem, and occasionally you do find that the dt_* objects are not correctly tagged as system objects in a particular database.
  
  We had this happen a few times, and although we have never identified what actually causes it to happen, we have the following script which will fix up things so these objects are once again tagged as system
  
  
  exec sp_MS_marksystemobject 'dtproperties'
  exec sp_MS_marksystemobject 'dt_addtosourcecontrol'
  exec sp_MS_marksystemobject 'dt_addtosourcecontrol_u'
  exec sp_MS_marksystemobject 'dt_adduserobject'
  exec sp_MS_marksystemobject 'dt_adduserobject_vcs'
  exec sp_MS_marksystemobject 'dt_checkinobject'
  exec sp_MS_marksystemobject 'dt_checkinobject_u'
  exec sp_MS_marksystemobject 'dt_checkoutobject'
  exec sp_MS_marksystemobject 'dt_checkoutobject_u'
  exec sp_MS_marksystemobject 'dt_displayoaerror'
  exec sp_MS_marksystemobject 'dt_displayoaerror_u'
  exec sp_MS_marksystemobject 'dt_droppropertiesbyid'
  exec sp_MS_marksystemobject 'dt_dropuserobjectbyid'
  exec sp_MS_marksystemobject 'dt_generateansiname'
  exec sp_MS_marksystemobject 'dt_getobjwithprop'
  exec sp_MS_marksystemobject 'dt_getobjwithprop_u'
  exec sp_MS_marksystemobject 'dt_getpropertiesbyid'
  exec sp_MS_marksystemobject 'dt_getpropertiesbyid_u'
  exec sp_MS_marksystemobject 'dt_getpropertiesbyid_vcs'
  exec sp_MS_marksystemobject 'dt_getpropertiesbyid_vcs_u'
  exec sp_MS_marksystemobject 'dt_isundersourcecontrol'
  exec sp_MS_marksystemobject 'dt_isundersourcecontrol_u'
  exec sp_MS_marksystemobject 'dt_removefromsourcecontrol'
  exec sp_MS_marksystemobject 'dt_setpropertybyid'
  exec sp_MS_marksystemobject 'dt_setpropertybyid_u'
  exec sp_MS_marksystemobject 'dt_validateloginparams'
  exec sp_MS_marksystemobject 'dt_validateloginparams_u'
  exec sp_MS_marksystemobject 'dt_vcsenabled'
  exec sp_MS_marksystemobject 'dt_verstamp006'
  exec sp_MS_marksystemobject 'dt_verstamp007'
  exec sp_MS_marksystemobject 'dt_whocheckedout'
  exec sp_MS_marksystemobject 'dt_whocheckedout_u'
  
  
  
  Hope it helps

  rgribble January 30, 2008 23:50

  - 0 +

Add comment

Please sign in to leave a comment.