Author |
Message |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
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.
|
|
Fri Jan 18, 2008 5:50 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7963
|
|
|
|
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?
|
|
Fri Jan 18, 2008 6:49 pm |
|
 |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
|
|
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.
|
|
Fri Jan 18, 2008 11:46 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7963
|
|
|
|
I think we currently support Oracle synonyms only, but I'll check.
|
|
Sat Jan 19, 2008 11:16 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7963
|
|
|
|
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.
|
|
Fri Jan 25, 2008 5:01 pm |
|
 |
|