xp's in SQL2000

  • Anyone know of alternatives to the following extended procs? They are in 7, but not 2000.

    master..xp_sqlinventory

    master..xp_sqlregister


    Be great!
    Michael

  • I don't have the output for those in front of me but have you compared it to xp_msver?

  • scott.shaw (8/5/2011)


    I don't have the output for those in front of me but have you compared it to xp_msver?

    Note this thread is almost 10 years old. I hope he has solved it by now... or upgraded to another version.

    Thanks for helping out tho :-).

  • Ha! That's too funny - I didn't even notice. My bad.

  • scott.shaw (8/5/2011)


    Ha! That's too funny - I didn't even notice. My bad.

    I think you've just set a new records... checking into it ATM. 😀

    pre-congrats :hehe:

  • Considering the original post was never answered, I'm cool with an answer 10 years later. 🙂

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Jeff Moden (8/5/2011)


    Considering the original post was never answered, I'm cool with an answer 10 years later. 🙂

    Same here... but it's still a little funny :hehe:.

  • I suffer from a medical condition called TFOCD - Technical Forum Obsessive Compulsive Disorder. It makes me believe that every forum question MUST have an answer.

    It's hard to live with but drinking copious amounts of whiskey helps.

  • I suffer from massive amounts of CRS and appreciate it when every forum question has an answer to I can look it up instead of having to remember it. 😀

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Jeff Moden (8/5/2011)


    I suffer from massive amounts of CRS and appreciate it when every forum question has an answer to I can look it up instead of having to remember it. 😀

    Catholic Relief Service?[/url]

  • The clean version is "Can't Remember Stuff". 😉

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 11 posts - 1 through 10 (of 10 total)

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