SQL 2005 - Synonyms and a bug

v. 3.0.31

I was trying to get Synonyms working using this query:

SELECT name, type, uid
FROM sysobjects
WHERE xtype IN ('SN')
AND uid = :SCHEMA_ID
and name = :OBJECT_NAME

However, I get a SQL Parameter binding error.

Then I tried removing the references to Synonyms by removing the query and it closed one Management Studio process (the one I was using) and left the other one open. SQL Assist remained open.

I'm sorry, I didn't get what you were trying to do. Did you try to create a new DB Query type for SQL Server called Synonyms and link it to the SQL Assistance Type?

I created a new query type called synonyms of type synonym for SQL. Then I associated that query type under the SQL group for synonyms. I also added type SN to the objects query. I tried out the assistance and received the binding error. I then was removing it, I don't remember which I removed first the selection or the query type.

I think we currently support Oracle synonyms only, but I'll check.

Support for SQL Server SYNONYMS has been added in version 3.1. This is currently available as a private build by invitation only. Please check it out. We will send you an invitation soon.