Post reply

removing dt_ stored procedures

  • October 5, 2005 at 4:09 pm

    #110212

    Hello everyone, I ran the sp_removedbreplication statement to stop replication. But the dt_ SPs are still in my database. What do I need to do to remove them? Thanks in advance for your help.

  • October 6, 2005 at 5:40 am

    #595406

    the dt_? stored procedures are not related to replication but are used to integrate with MS Visual Source Safe.

    As Service Patchs might assume that these procedures exists and the installatiuon might fail if the dt_? procedures are removed, recommend taking no action.

    SQL = Scarcely Qualifies as a Language

  • October 6, 2005 at 6:11 am

    #595416

    I believe these tables are also used with Visual Studio ( maybe for the source control part?? ) and the diagramming in Enterprise Manager.

    Short answer don't remove them.

    --------------------
    Colt 45 - the original point and click interface

  • October 6, 2005 at 8:40 am

    #595496

    Thank you gentlemen.

  • October 7, 2005 at 2:20 pm

    #596064

    As far as I know the 'dt' stored procedures are used with the SQL diagramming tool (hence 'dt'). They first apepared in v7.0. The procedures are created 'auto-magically' when you launch the diagramming tool in a given database for the first time. Also if memory serves cirrectly you can delete them even with an existing diagram and they will be recreated (memory fails so I'd script them out first on a test server to retest this). No need to worry if they do not exist when appying SQL Server service packs as they are smart enough to knwo the difference in this instance.

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

Viewing 5 posts - 1 through 5 (of 5 total)

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