Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

execution of sql statement on a linked server Expand / Collapse
Author
Message
Posted Wednesday, August 25, 2010 5:35 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, November 27, 2014 5:54 AM
Points: 403, Visits: 295
What are the problems in execution of sql statement on a linked server...

Is constraints are available in local server when exec queries on linked server....

What are the common problems we may get when working with linked servers.....
Post #974753
Posted Wednesday, August 25, 2010 7:23 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, August 1, 2014 6:18 AM
Points: 1,618, Visits: 20,980
Any error messages that you get? Looks like an interview question to me

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Post #974835
Posted Wednesday, August 25, 2010 7:37 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, November 27, 2014 5:54 AM
Points: 403, Visits: 295
actually it is asked by an interviewer.......
The question is...there are two tables emp and dept has foreign key relation..
If we retrieve the result from emp using linked server.... what will be for constraint....

I need to know what are possible errors.......when a table has constraints like foreign, check, default etc.....
Post #974850
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse