SQL Prompt glitch when SQL Server contains an invalid SYNONYM reference.

EnrightMcC

I had a SYNONYM defined in SQL Server that pointed to a server that no longer exists. SQL Prompt couldn't load suggestions (Error loading master) because the internal query
"SELECT object_id, OBJECTPROPERTYEX(object_id, 'BaseType') from [sys].[synonyms] WITH(NOLOCK);"
After I dropped the invalid synonym it worked fine. None of my SQL code referenced the dead server;

Jessica R

Hi @EnrightMcC,

Thanks for your post on this!

This is a known issue as SQL Prompt unfortunately doesn't check for synonym validity at the moment. It would definitely make sense for SQL Prompt to do this though- can you please post a request for this on our UserVoice forum here: https://redgate.uservoice.com/forums/94413-sql-prompt

That will allow us to keep track of requests for this and also keep you updated on any progress.

Thank you!