Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
humanpuck
Yak Posting Veteran
94 Posts |
 Posted - 2006-07-21 : 14:30:32
|
| Is there a way to select from one server to another if you have the IP address of the other server, but not the name.IESelect a.columna,a.columnb,b.columnbfrom table1 a innerjoin myServer.myDB.dbo.table2 b ona.columna = b.columnaInstead of the myServer I have an IP addressSelect a.columna,a.columnb,b.columnbfrom table1 a innerjoin 10.129.254.13.myDB.dbo.table2 b ona.columna = b.columna |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
|
|
humanpuck
Yak Posting Veteran
94 Posts |
Posted - 2006-07-21 : 15:10:08
|
| Thanks for the suggestion Srinika, but I can connect directly to the ip address in QA and EM. What I'm really trying to do is an insert into the named servers tbl from same tbl on the server that I only have the IP address for. I'm just really trying to sync up the development tbl with production. |
 |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-07-21 : 15:15:56
|
| No Dear,What I'm trying to say is, once u registered that as a SQL server in ur EM, then it can be refeered to as any other SQL server in the internet. May be I misunderstood ur question. check these as well:http://www.databasejournal.com/features/mssql/article.php/3116011http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=52040Srinika |
|
|
|
humanpuck
Yak Posting Veteran
94 Posts |
Posted - 2006-07-21 : 15:30:49
|
| No no you're right. The first one worked like a charm. I read it wrong, I do that on Fridays. I was able to assign it an alias. |
|
|
|
|
|
|
Select Help