SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Joins on linked servers using functions

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Joins on linked servers using functions
Author Message
judahr



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

Post Joins on linked servers using functions Reply with quote
v2.5.14

Querying joining a linked server table to a local server table using a function causes it to hang for about 15-20 seconds. Example.

Select *
From dbo.Names n INNER JOIN LinkedServer.Database.dbo.OtherTable ot ON n.ID = Convert(int,


Typing after this point causes this error after just about every keystroke:

---------------------------
SQL Assistant - Error
---------------------------
Exception: CheckKey(44,3342337)
---------------------------
OK
---------------------------
Tue Aug 21, 2007 9:28 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Reply with quote
SQL Assistant doesn't currently support linked servers. We are trying to stay away from linked servers because of so many known problems with them. If you are coding distributed queries involving linked server tables or views pointing to linked tables, please use the Suspend menu in SQL Assistant to suspend it temporarily. You can resume SQL Assistant after you are done with such query.
Tue Aug 21, 2007 10:04 am View user's profile Send private message
judahr



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

Post Reply with quote
I'd rather it be able to detect that it is referencing a linked server and simply not display a popup, than to freeze the window. BTW, Query Analyzer frees up a lot faster than Management Studio.
Tue Aug 21, 2007 11:04 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Reply with quote
Query Analyzer uses ODBC, while Management Studio uses SMO. Not that it matters for SQL Assistant, but the internal working of these protocols is different, that's why you see some differences in response times.

Not sure if this is going to help, but you can try customizing database catalog queries in SQL Assistant options (start with "Objects" query) and adding some filters to the WHERE clause excluding anything that starts with your linked server name.
Tue Aug 21, 2007 11:21 am View user's profile Send private message
tarik



Joined: 26 Nov 2007
Posts: 7

Post Reply with quote
I know it's a pretty old topic - but is there a way to query the linked server, if I know that I surely want to?
Wed Aug 27, 2008 9:47 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Reply with quote
No. We are not planning on supporting Linked Servers because Linked Servers is very unstable future by design. If a linked server connection is not configured correctly or a bad driver is used, it can easily crash the server, which happens quote often. We don't want to deal with complains that SQL Assistant crashed production server or even waste time investigating such reports.


Besides, you can always create a local view pointing to remote server and using OPENQUERY or similar method. SQL Assistant can be then used to query the local view.
Wed Aug 27, 2008 10:05 am 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.