Viewing 4 posts - 1 through 4 (of 4 total)
if you have created linked server,then use format "ServerName.DatabaseName.SchemaName.TableName" you can write your sql.
November 10, 2006 at 11:03 pm
#671209
PIVOT can solve your problem.
November 10, 2006 at 6:39 pm
#671200
I think uncommitted transaction running long time lead to this. You can try to find is it exist?
November 10, 2006 at 6:28 pm
#671199
I think replication is the best way because it is easy to configure and need not many manage.
November 10, 2006 at 6:23 pm
#671198