Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 612
  • Last Modified:

Stored procedures starting dt_

I have SQL Server 6.5  in Production .
Off late I could see some stored procedure got created in the production database .
There are total 18 Stored procedure of that type , all prefixed with dt_ .
For ex.
dt_addtosourcecontrol          
dt_adduserobject              
dt_adduserobject_vcs          
dt_checkinobject              
dt_checkoutobject
etc .

Can any body suggest me where these objects have come from , any other tool etc .

Thanks.
0
blks
Asked:
blks
  • 2
1 Solution
 
simonsabinCommented:
These are stored procedures that are created by Visual Studio (interdev in particular) to be able to use source control with the stored procedures.

If you are using interdev sourcecontrol on you Sps then you should have a process in your release mechanism that eliminates these. Also If your prod. server has interdev server on it and you connect to it with interdev then they will keep coming back.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I can confirm simonsabin, and that the same happens on SQL Server 7
0
 
blksAuthor Commented:
Answer accepted
0
 
blksAuthor Commented:
Thanks guys , I got the answer .
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now