January 6, 2005 at 3:34 am
Hey. In a procedure that is stored on one SQL server I need to search trhough tables that are only part of another SQL server on another machine.
what is the syntax for the connection?
thanks
January 6, 2005 at 3:49 am
Have a look at "linked server" or OPENQUERY in BOL.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
January 6, 2005 at 5:54 am
thanks, and sorry about double post, it was not intentional
December 15, 2005 at 6:04 am
I need to do the same thing, I have linked servers but still get "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection."
Any ideas?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply