linked server support?

fei2010

sql prompt 3 supposes to support linked server. but seems not working for me.

I am using SSMS 2005, I have a linked server (SQL 2005) B in sql 2005 server, when I type "B." it doesn't pop up anything.

is there any settings I need to enable? I do have the cross database and linked server option checked and cross database is working fine but not linked server.

tanya

Hi,

Can you confirm if the database that you are trying to connect with a linked server query is not listed in connections to ignore? (SQL Prompt menu - options-Connections - Connections to ignore)
Also, can you try refreshing the cache (SQL Prompt - Refresh cache) to ensure this is not anything to do with the linked server not being cached?

Please let us know if you continue to have this issue and if you could tell us the version number of SQL prompt (SQL Prompt menu - About) that you are using it would be useful.

Thanks,
Tanya
Project Manager
Red Gate Software Ltd