SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
SQL 2005 - Synonyms and a bug

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
SQL 2005 - Synonyms and a bug
Author Message
judahr



Joined: 09 Mar 2007
Posts: 314
Country: United States

Post SQL 2005 - Synonyms and a bug Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6500

Post Reply with quote
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 View user's profile Send private message
judahr



Joined: 09 Mar 2007
Posts: 314
Country: United States

Post Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6500

Post Reply with quote
I think we currently support Oracle synonyms only, but I'll check.
Sat Jan 19, 2008 11:16 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6500

Post Reply with quote
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 View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.