Linked server provider is not accessable

  • Hi,

    I am using SQL SERVER 2005 Standard Edition 64 BIT with Service pack 3. From past few days I am facing a strange issue, whenever I am trying to expand the linked server provider details, one new active process is getting started which actually executing the system stored procedure xp_enum_oledb_providers(found through INPUTBUFFER) & is never getting completed.

    Every time we restart the SQL services, for 5 - 10 mins the the providers can be accessed & then the same problem getting started. because of this all the queries is getting hanged which is using linked server.

    Please help me with the solution. Thanks in advance.

  • Hello all,

    The issue got resolved 😀 . Actually the Dll xpstar.dll which is being called from the extended stored procedure xp_enum_oledb_providers got corrupted.

Viewing 2 posts - 1 through 1 (of 1 total)

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