[thelist] ADOX question

[David.Cantrell at Gunter.AF.mil]

>add_event;1 is the 1st version of the add_event sp.  You could also have an
>add_event;2 and ;3 and so-on.

Interesting, I didn't know it did that. How do I update the version number?
I've modified most of them over time, but they all still report version 1...

>How did you create these stored procs?

Manually using Query Analyzer, e.g. "create proc foobar @yadda yadda
yadda..."

There's about 250 of them.

I'm trying to gather metrics on them and find similarities, what is and
isn't being used, etc so I can trim the database. I figure I can probably
lose 25% of the procedures due to redundancy, testing/experimenting, or
because they are orphaned and no longer used.

Thanks for your help, it answered one of my questions! :)
-dave