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 |
|
aiken
Aged Yak Warrior
525 Posts |
 Posted - 2004-09-18 : 13:38:16
|
I'm working with two servers that support a single application. Both are SQL server 2000.One of the servers primarily handles logging data; the the primarily handles the actual application. The front ends all talk to the application DB server, and the application DB server talks to the logging DB server to log activity.Right now, the app is kind of a mess -- some of the application SP's call logging SP's on the linked server ("exec logsql.logdb.dbo.pLogWhatever"). Other application SP's insert data diretly into the tables on the linked server ("insert into logsql.logdb.dbo.tLogWhatever...").Is there a preferred way of doing this? I'd like to standardize, and of course if there are performance benefits one way or the other, that would be nice too  Thanks-b |
|
|
|
|
|
Accessing data from linked server