I have a linked server and I'm having a tough time referencing it properly.If I open SQL Management Studio and run a query on the server itself it works great.However, I want to take that query ...

The new arch-enemy of Microsoft SQL Server has slammed many networks with bogus data. Spida has caused traffic to a server port to jump by a factor of 40 in some reported cases.

Spida ensnares MS SQL servers A new Internet worm, written in JavaScript, scans the Web on port 1433 and collects passwords from vulnerable servers. Robert Vamosi tells you how to avoid Spida's web.