I believe that you have to specifiy the full path in the add extended proc command

exec sp_addextendedproc 'xp_TestDataComm', '{FULLPATH}\xpDataComm.dll'

Hi just a quick note to say thank you for the ideas unfortunately none of which worked.

THanks you all for your contributions though.

I could not agree more with the editorial and have always sort to ensure that my company’s data is protected by the best possible practice but when you work for...

Hi Grasshopper,

I have tried that but still the same error.

My syntax works fine on at least five other pc's and servers so we have come to the conclusion that we...

Hi,

We have checked the WMI and that seems to be working correctly, but thanks for the tip.

In fact we have been through everything with a fine tooth comb checking...

Hi,

Thanks I will check that and I will let you know.

Hi,

Just thought I would update you on how I got on with the Advisor. I had to script the objects onto a smaller 2000 instance before I could run the...

No problem, at least I have a bit more view on the subject. Thanks for the link but I had already seen that.

I am going to script the objects over...

The analyse trace file facilty doesn't really help as you still need to be able to connect to the database you want to check on a 2000 server which is...

Hi Mohit,

Right got you. I have just made a connection from the Advisor to an SQL instance and there is an option to analyse a profile trace file. Ok, I...

Hi Mohit,

If I understand you correctly I capture a Replay Profiler trace to a table either directly onto an SQL 2000 server or import it afterward.

Then I can connect to...

Hi Greg, Thanks for the reply. I had thought about using the 2008 Advisor but I was not sure how many false positives it might give me, although it might...

Hi,

Yes that was one of my conclusions thanks. Horse and Stable door spring to mind! 🙂

I totally agree with Manie Verster and his article Knowledge Sharing. I have found sites like SQL ServerCentral invaluable and have scoured the many articles that have been posted here...

Hi,

Yes we have experienced the problem of SQL Agent worker threads on SQL 2000, which is why I know about the article.

I must admit I missed the bit about SQL...