• @ harita

    You need to increase the remote query timeout option in SSMS

    SSMS-->prop-->connections-->remote qery timeout--> wats the value??

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP