Linked server limitation?

Question

Post reply

Linked server limitation?

xzd000

SSC Veteran

Points: 298
More actions
July 7, 2010 at 12:09 am

#237305

Hi
Does the usage of linked server have any limitation? For eg, on insert,delete,update to the linked server? Some command that's not possible on linked server?
July 7, 2010 at 12:32 am

This was removed by the editor as SPAM

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 1

xzd000 (7/7/2010)
Does the usage of linked server have any limitation?

Yes it does.

xzd000 (7/7/2010)
For eg, on insert,delete,update to the linked server?

There are some.

xzd000 (7/7/2010)
Hi
Some command that's not possible on linked server?

Yes, they exists.

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 2

There are limitations. One of the first you'll need to take into account is the fact that the transactions are running through DTC as distributed transactions. That alone limits what you can do, even with linked SQL Servers. But there are lots of others. Using EXECUTE AS within a procedure can cause problems. You can't use XML as an input parameter for queries run through a linked server... there are lots of them. I'm not aware of anywhere that they're summarized. Partly it's because the limitations are caused, not simply because the server is linked, but by what you are linking to. For example, you can link to an Excel file. Hopefully you won't be shocked to find that you can't run certain TSQL commands against that file.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

xzd000 SSC Veteran Points: 298 More actions · Answer 3

stewartc-708166 (7/7/2010)
The answer to that is "it depends"
dependencies may include:
> type of database (e.g. SQL Server, Oracle, DB2, Informix)
> version(s) of database(s)
> architecture (x86, x64, IA64)
> processing power
> RAM
> Network topology
> how the query is written (e.g. using four-part naming or OPENQUERY)
for a more accurate reply, please answer these questions.

OK my query might have seemed too generalized.

Hardware limitations aside, I'm concerned with what wont work on a sql server linked to another SQL server.

Basically from the replies I ascertain that command level wise, all T-SQL commands will work on the linked SQL Server too..?

However,what do you mean by this?

Eugene Elutin (7/7/2010)
xzd000 (7/7/2010)
For eg, on insert,delete,update to the linked server?
There are some.
.

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 4

The basic commands will work. As you get into more complicated scenarios, some things will work and some won't.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning