Stored procedures starting dt_

Posted on 2000-03-20
Last Modified: 2013-11-30
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.
etc .

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

Question by:blks
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2

Accepted Solution

simonsabin earned 50 total points
ID: 2637980
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.
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 2638956
I can confirm simonsabin, and that the same happens on SQL Server 7

Author Comment

ID: 2881324
Answer accepted

Author Comment

ID: 2881325
Thanks guys , I got the answer .

Featured Post

MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
CAST issue with SQL 2000 15 42
store vs query adhoc - no show rows 4 35
Need more granular date groupings 4 43
SQL Server Error: 4060 8 26
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question