How can we help you today? How can we help you today?

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

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;
EnrightMcC
0

Comments

1 comment

Sort by
  • 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!
    Jessica R
    0

Add comment

Please sign in to leave a comment.