SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Sunny / Failed to load Msxmlsql.dll / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 23:16:03 GMT20Failed to load Msxmlsql.dllhttp://www.sqlservercentral.com/Forums/Topic1241184-640-1.aspxHello!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 1Failed to load Msxmlsql.dll.How do I solve this error?Thanks!!!Tue, 24 Jan 2012 13:45:39 GMTprogramador4