We have a peculiar issue in SQL Server 2005. When we try to access the Providers under linked servers in SSMS (Management Studio), we are unable to view the providers and in the sessions (sp_Who2) we are seeing that the stored procedure xp_enum_oledb_providers is running. There are different applications using Oralce linked servers (user created) are showing up as running (but now getting completed). All the sessions are displayed as running and when the Max threads (128) are reached the Server is not responding.
Help on this is much appreciated