Post reply

Extended SP "sp_XML_preparedocument " missing

  • January 18, 2011 at 8:51 am

    #245549

    I have this extended SP "sp_XML_preparedocument" missing on both the SQL 2005 sp4 and SQL 2008 R2.

    Anyone please tell me how could I put them back or I need to reinstall them !?

    Thanks!

  • January 19, 2011 at 10:46 am

    #1275432

    Anyone extend your hand to this Extended stored procedure help before it sinks to the bottoooom????????

    Thanks!!!!:crying:

  • January 19, 2011 at 10:56 am

    #1275441

    It should be there in master, under the system extended stored procedures. It's part of a default instalation.

    I haven't used it in years, since XQuery is easier for me, but it appears to be in there on all of my servers.

    If it's really missing, you may need to reinstall SQL Server. But I'd be surprised if it's gone.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • January 19, 2011 at 1:53 pm

    #1275560

    OK! Thanks. Any other suggestions !? They do not exist on my 2005/2008.

  • January 19, 2011 at 2:10 pm

    #1275570

    Are you sure you're searching the correct folder?

    Do you see the sp_batch_params procedure?

    How did you notice it's missing? Do you get any error message when calling the sproc? If so, what's the error message?


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • January 20, 2011 at 9:05 am

    #1276008

    Thanks. I have removed the SQL 2005 and re-installed and it seems to be going.

    Thank you again ALL!:-)

  • January 21, 2011 at 6:20 am

    #1276499

    You're welcome. Well done on fixing it.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 7 posts - 1 through 6 (of 6 total)

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