Hiearchial Storage of SP's?

  • We have a ton of SPs for various applicationions. Is there a way to logically store the SPs in something like folders in SQL7 or 2000? For example we have several apps that use the same database, but have different SPs. I know we can put a prefix on the SP to make them order together, but it would be great to create a folder or something.

    I don't believe there is such a thing in 7.0, but we are going to 2000 in the future and are curious if that capability will be there.

    Thanks

  • So far there is not, best you can do is use a naming convention, from within EM or ISQW anyway. Might be 3rd party tools that would do it, have not looked.

    Andy

  • No, and I have not seen anything for a future implementation like this. You might want to suggest to Microsoft and see what happens.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply