Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have inherited a database from a predecessor who is long gone... There are about a hundred stored procs in the database that all start with dbo.M7_ They appear to be something to do with source control of some sort, but I have no idea what product they are associated with. I don't see any connection between them and any other table/proc. I would like to remove them from my system but I need to understand why they were there first. No one who is still here remembers what they do, they just remember them showing up in the database one day.

Does anyone know what they are?

share|improve this question
2  
Any clues in the stored procedure definitions? –  Martin Smith Jun 12 '13 at 14:38
    
Does it cause any problems ? Better is to run a server side sql trace (week or month - u have to decide based on your business cycle) to check if they are being called by any application or not. –  Kin Jun 12 '13 at 14:39
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.