Failed to load Msxmlsql.dll

• programador4

  SSC Rookie

  Points: 45

  More actions

  January 24, 2012 at 1:45 pm

  #255355

  Hello!

  Please!!

  I have an SQL Server 2008 Enterprise instance.

  I can't use sp_xml_preparedocument SP.

  For example, when I try use this:

  declare @var1 int

  declare @var2 int

  exec @var2 = sp_xml_preparedocument @var1 output, '<abc><name>Sumit</name></abc>'

  appears the error:

  Msg 6610, Level 16, State 1, Procedure sp_xml_preparedocument, Line 1

  Failed to load Msxmlsql.dll.

  How do I solve this error?

  Thanks!!!