I need to write a compound query to access two different SQL servers. When I specify the server name as a prefix to the database name i get syntax error. I can not seem to find any examples of how to qualify which server i want to access the database from. I need to access two databases that are located in two different servers.
I am using SQL server mgt studio and connected to both servers.
ljpitre
Last Activity: Jul 22 '09, 06:26 PM
Joined: Jul 15 '09
Location: Lafayette, Louisiana
-
Multiple SQL servers in same query
-
Nth location of string
Assuming the following: I do not have privileges to write a user defined function in the database and I'm not allowed to use VB, Using strickly SQL and built-in functions,
I need to get the starting column of the Nth occurance of a string contained in another string.
Example:
AT('one$two$thr ee$four$five$', '$', 2)
returns the starting position in the first string of the second string for...
No activity results to display