that's actually really depressing since I already upgraded to SP3 but it seemed to describe my exact problem.

I ran the stored procedure you posted, but still no joy on the...

So as a hail mary I decided to reboot my machine, now a catolog folder shows up, but when I try to expand it, I get the following error:

Cannot obtain...

WiltsDBA (11/3/2009)

---

Oh, and a thought:

If you right-click on the linked server, choose properties and click "security" in the left pane, at the bottom do you have "Be made using this...

Here's the script of the linked server. For whatever reason it does not include the user I mapped.

/****** Object: LinkedServer [SSWEBAPP] Script Date:...

WiltsDBA (11/3/2009)

---

Shouldn't be.

If you can only see the local connection in your processlist, then the linked server isn't making a connection.

If you run management studio, expand server objects, linked servers,...

Thanks for the reply!

SHOW PROCESSLIST only shows the local connection.

Hi, I just set up a MYSQL linked server and any query I pass to it just endlessly runs, never times out or gives an error.

I used the new 5.31...