linked server support?

fei2010fei2010 Posts: 13
edited July 7, 2008 10:32AM in SQL Prompt Previous Versions
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.


  • 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.

    Project Manager
    Red Gate Software Ltd
Sign In or Register to comment.