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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-10-31 : 07:19:38
|
| padma writes "I need take data from one server1 and have to place it in another server2.and if any modifications done at server1 it should automatically effect the server2 database.Using triggers how to specify the path of the table of server1." |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-10-31 : 10:17:06
|
setup linked servers. use 4 part naming convention:select * from servername.dbname.ownerName.TableNamealso look into replication. it's what you want for this issue.Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
 |
|
|
|
|
|
sql