Removing dt_ stored procedures
-
I have inherited several databases and they have the set of dt_ stored procedures for sourcesafe integration. These are marked as system objects, so cannot be deleted in the usual way. Does anyone have a simple script to remove them
Thanks in advance.
Paul Ibison PhD, MCSD
email: Paul.Ibison@btinternet.com
Paul Ibison
Paul.Ibison@replicationanswers.com -
Why do you want to remove them? (I know thats not an answer!)
Andy
-
We don't use them and will be implementing our own solution, so I'd like to do a clear out.
Paul Ibison PhD, MCSD
email: Paul.Ibison@btinternet.com
Paul Ibison
Paul.Ibison@replicationanswers.com -
Have you tried DROP TABLE from ISQL. I know that SQLEM blocks these but I have had luck with this. If this does not work, I can give you the workaround to making the table a non-system table. But try this first.
-
Unless your new solution uses the same proc names with a new implementation, why bother? You never know when some other app may use them (or at least look for them), plus when you install a service pack they may well get replaced.
I am able to drop one of them using the following executed in Query Analyzer:
drop procedure dt_addtosourcecontrol_U
Andy
-
thanks Andy, your solution works well. I was using the SQL 7 EM to try to do the same and it was disallowed, so I didn't think of direct stored proc manipulation. As an aside, if anyone else has this issue, I've found that using SQL2000 EM tools, even on a SQL 7 database also works.
Paul Ibison PhD, MCSD
email: Paul.Ibison@btinternet.com
Paul Ibison
Paul.Ibison@replicationanswers.com
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply