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.