Post reply

Could not find stored procedure 'XP_MSVER'

  • June 3, 2008 at 2:26 pm

    #122649

    I'm trying to run 'XP_MSVER', but get an error.

    I see it in the Master DB, I'm in master when I try to run it, and and it works on my other server.

    Some dumb user error ?

  • June 3, 2008 at 3:24 pm

    #823890

    I ran it on my box sight-unseen, no problems. I was in the master database, and from an SSMS query window just ran

    xp_msver

    without EXECUTE, sys., or anything. My knee-jerk reaction is, do you have sufficient privileges to run that routine?

    Philip

  • June 4, 2008 at 1:05 am

    #824018

    xp_msvr will run on any dbs.

  • June 4, 2008 at 3:19 am

    #824053

    I guess you might have the Sql Server collation as case sensitive and hence the error. Can you try using xp_msver or XP_MSVER check the procedure and see the naming convention and just copy paste them identically..

    [font="Verdana"]- Deepak[/font]

  • June 4, 2008 at 7:45 am

    #824177

    Deepak (6/4/2008)

    I guess you might have the Sql Server collation as case sensitive and hence the error. Can you try using xp_msver or XP_MSVER check the procedure and see the naming convention and just copy paste them identically..

    D'OH !! That was it .... Hold on while I bang my head on the desk in embarrasment.

Viewing 5 posts - 1 through 4 (of 4 total)

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