execution of sql statement on a linked server

  • 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.....

  • Any error messages that you get? Looks like an interview question to me

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • 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.....

Viewing 3 posts - 1 through 2 (of 2 total)

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