Usage of xp_servicecontrol is unsupported

I have seen some posts (and some forums) discussing about using xp_servicecontrol. There was also a ticket opened where xp_servicecontrol reports a wrong status of some of the SQL Server services. I wanted to make sure that everyone knows that xp_servicecontrol is an undocumented XP.  This XP has been a part of SQL Server since 7.0…

0

SQL Server 2008 transactional replication to DB2 subscriber can fail with: DB2OLEDBV2: Error "System.DllNotFoundException: Unable to load DLL ‘mseidrda.dll’: The specified module could not be found

Recently came across a situation where the DB2 subscriber was failing with the below <error>DB2OLEDBV2: Error “System.DllNotFoundException: Unable to load DLL ‘mseidrda.dll’: The specified module could not be found</error>DB2 provider was installed from the SQL Server 2008’s feature pack-http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=b33d2c78-1059-4ce2-b80d-2343c099bcb4 To resolve this, we removed the Microsoft.HostIntegration.DataAccessLibrary.dll file located in the C:\Windows\assembly directoryAfter this, we were…

0