• Total WAG...but I have seen things like this where the developers were informed (for whatever reason) that stored procedures require a parameter and therefore they built everything with a parameter whether or not it was used.

    I have also seen similar development methods used when the developers built a generic utility in code and that utility required all stored procedures to have a parameter - because if it didn't, their nice little generic utility would break.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs