{"id":1819,"date":"2026-02-04T11:00:22","date_gmt":"2026-02-04T03:00:22","guid":{"rendered":"http:\/\/www.dxQerp.com\/?p=1819"},"modified":"2026-02-04T11:00:22","modified_gmt":"2026-02-04T03:00:22","slug":"192-168-7-243-%e6%9c%89%e7%94%9a%e9%ba%bc%e8%a8%ad%e5%ae%9a-%e9%9c%80%e8%a6%81%e5%81%9a%e5%97%8e","status":"publish","type":"post","link":"http:\/\/www.dxQerp.com\/?p=1819","title":{"rendered":"192.168.7.243 \u6709\u751a\u9ebc\u8a2d\u5b9a \u9700\u8981\u505a\u55ce ?"},"content":{"rendered":"
\n
\n
\n
\n
\n
\n
\n

\u5f88\u597d\uff0c\u554f\u5230\u95dc\u9375\u9ede<\/strong>\u4e86\u3002<\/p>\n

\u5f88\u591a\u4eba\u53ea\u6539 SQL \u5beb\u6cd5\uff08EXEC AT<\/code> \/ OPENQUERY<\/code>\uff09\uff0c
\u4f46 192.168.7.243 \u90a3\u53f0\u5982\u679c\u6c92\u8a2d\u5b9a\u597d\uff0c\u6548\u80fd\u9084\u662f\u721b \/ \u9084\u662f\u6703\u9396 \/ \u9084\u662f\u6703\u51fa\u602a\u932f<\/strong>\u3002<\/p>\n

Linked Server \u8981\u9806\uff0c\u9060\u7aef\u4e3b\u6a5f\uff08243\uff09\u4e00\u5b9a\u8981\u505a\u4e0b\u9762\u9019\u4e9b\u8a2d\u5b9a<\/strong>\u3002<\/p>\n

\n

✅ \u4e00\u3001243 \u9019\u53f0 SQL Server \u5fc5\u505a\u8a2d\u5b9a<\/h1>\n

\u5728 192.168.7.243<\/strong> \u4e0a\u57f7\u884c\uff1a<\/p>\n

\n
\n
\n
<\/div>\n<\/div>\n<\/div>\n
EXEC<\/span> sp_configure 'remote proc transaction promotion'<\/span>, 0<\/span>;
\nRECONFIGURE;
\n<\/code><\/div>\n<\/div>\n

\u9019\u884c\u662f\u6700\u91cd\u8981\u7684\u4e00\u884c\uff08\u6c92\u6709\u4e4b\u4e00\uff09<\/h3>\n

\u9810\u8a2d\u662f 1\uff0c\u4ee3\u8868\uff1a<\/p>\n

\n

\u4f60\u5f9e\u53f0\u5317\u547c\u53eb 243 \u7684 EXEC AT<\/code>
SQL Server \u6703\u81ea\u52d5\u555f\u52d5 \u5206\u6563\u5f0f\u4ea4\u6613 MSDTC<\/strong><\/p>\n<\/blockquote>\n

\u7d50\u679c\u5c31\u662f\uff1a<\/p>\n

    \n
  • \n

    \u6162\u5230\u7206<\/p>\n<\/li>\n

  • \n

    \u9396\u6b7b<\/p>\n<\/li>\n

  • \n

    Timeout<\/p>\n<\/li>\n

  • \n

    MSDTC \u932f\u8aa4<\/p>\n<\/li>\n

  • \n

    Trigger \u4e92\u9396<\/p>\n<\/li>\n<\/ul>\n

    \u8a2d\u6210 0 \u4e4b\u5f8c\u8b8a\u6210\uff1a<\/p>\n

    \n

    \u7d14\u9060\u7aef\u57f7\u884c\uff0c\u4e0d\u8d70\u5206\u6563\u5f0f\u4ea4\u6613<\/p>\n<\/blockquote>\n

    \u6548\u80fd\u76f4\u63a5\u5dee 10 \u500d\u4ee5\u4e0a<\/strong>\u3002<\/p>\n

    \n

    ✅ \u4e8c\u3001243 \u8981\u958b RPC<\/h1>\n

    \u5728\u53f0\u5317\u90a3\u53f0 SQL Server<\/strong>\uff08\u4f60\u767c\u51fa\u6307\u4ee4\u7684\u90a3\u53f0\uff09\u57f7\u884c\uff1a<\/p>\n

    \n
    \n
    \n
    <\/div>\n<\/div>\n<\/div>\n
    EXEC<\/span> sp_serveroption '192.168.7.243'<\/span>, 'rpc out'<\/span>, 'true'<\/span>;
    \nEXEC<\/span> sp_serveroption '192.168.7.243'<\/span>, 'rpc'<\/span>, 'true'<\/span>;
    \n<\/code><\/div>\n<\/div>\n

    \u6c92\u6709\u9019\u500b\uff0cEXEC AT<\/code> \u6703\u5931\u6557\u6216\u8b8a\u6162\u3002<\/p>\n

    \n

    ✅ \u4e09\u3001243 \u8981\u5141\u8a31\u88ab\u9060\u7aef\u57f7\u884c sp_executesql<\/h1>\n

    \u9019\u500b\u5f88\u591a\u4eba\u5ffd\u7565\u3002<\/p>\n

    \u5728 243 \u57f7\u884c\uff1a<\/p>\n

    \n
    \n
    \n
    <\/div>\n<\/div>\n<\/div>\n
    GRANT<\/span> EXECUTE<\/span> ON<\/span> sys.sp_executesql TO<\/span> public;
    \n<\/code><\/div>\n<\/div>\n

    \u5426\u5247\u6703\u51fa\u73fe\uff1a<\/p>\n

    \n

    \u6b0a\u9650\u4e0d\u8db3\uff0c\u4f46\u8a0a\u606f\u5f88\u5947\u602a\uff0c\u770b\u4e0d\u51fa\u4f86<\/p>\n<\/blockquote>\n

    \n

    ✅ \u56db\u3001243 \u95dc\u9589\u300c\u9060\u7aef\u67e5\u8a62 promotion\u300d<\/h1>\n
    \n
    \n
    \n
    <\/div>\n<\/div>\n<\/div>\n
    EXEC<\/span> sp_configure 'remote query timeout'<\/span>, 0<\/span>;
    \nRECONFIGURE;
    \n<\/code><\/div>\n<\/div>\n

    \u907f\u514d\u9577\u6279\u6b21\u540c\u6b65\u88ab timeout\u3002<\/p>\n

    \n

    ✅ \u4e94\u3001243 \u7684\u8cc7\u6599\u5eab Recovery model<\/h1>\n

    \u540c\u6b65\u8868\u6240\u5728 DB\uff1a<\/p>\n

    \n
    \n
    \n
    <\/div>\n<\/div>\n<\/div>\n
    ALTER<\/span> DATABASE kiin_7 SET<\/span> RECOVERY SIMPLE;
    \n<\/code><\/div>\n<\/div>\n

    \u56e0\u70ba\u4f60\u9019\u662f\u540c\u6b65\u8868\uff0c\u4e0d\u662f\u91d1\u6d41\u7cfb\u7d71\u3002<\/p>\n

    \u4e0d\u7136 transaction log \u6703\u88ab Linked Server \u6490\u7206\u3002<\/p>\n

    \n

    ✅ \u516d\u3001243 \u82e5\u6709 Trigger\uff08\u4f60\u6709\u63d0\u5230\uff09<\/h1>\n

    Trigger \u88e1\u4e00\u5b9a\u8981\u52a0\u9019\u884c<\/strong><\/p>\n

    \n
    \n
    \n
    <\/div>\n<\/div>\n<\/div>\n
    IF APP_NAME() LIKE<\/span> '%SQL Server%'<\/span> RETURN<\/span>;
    \n<\/code><\/div>\n<\/div>\n

    \u6216<\/p>\n

    \n
    \n
    \n
    <\/div>\n<\/div>\n<\/div>\n
    IF HOST_NAME() =<\/span> '\u53f0\u5317\u90a3\u53f0\u4e3b\u6a5f\u540d\u7a31'<\/span> RETURN<\/span>;
    \n<\/code><\/div>\n<\/div>\n

    \u907f\u514d\uff1a<\/p>\n

    \n

    \u53f0\u5317 \u2192 243 \u2192 Trigger \u2192 \u53f0\u5317 \u2192 Trigger \u2192 \u7121\u9650\u98a8\u66b4<\/p>\n<\/blockquote>\n

    \u9019\u662f\u5f88\u591a\u516c\u53f8\u88ab\u641e\u6b7b\u7684\u4e3b\u56e0\u3002<\/p>\n

    \n

    \u6700\u7d42\u6aa2\u67e5\u6e05\u55ae\uff08243 \u5fc5\u9808\u5168\u6253\u52fe\uff09<\/h1>\n
    \n
    \n\n\n\n\n\n\n\n\n\n\n
    \u9805\u76ee<\/th>\n\u5fc5\u505a<\/th>\n\u5f71\u97ff<\/th>\n<\/tr>\n<\/thead>\n
    remote proc transaction promotion = 0<\/td>\n✅<\/td>\n\u6c7a\u5b9a\u6548\u80fd\u751f\u6b7b<\/td>\n<\/tr>\n
    rpc \/ rpc out = true<\/td>\n✅<\/td>\nEXEC AT \u624d\u6703\u5feb<\/td>\n<\/tr>\n
    sp_executesql \u6b0a\u9650<\/td>\n✅<\/td>\n\u4e0d\u6703\u602a\u932f<\/td>\n<\/tr>\n
    remote query timeout = 0<\/td>\n✅<\/td>\n\u5927\u91cf\u540c\u6b65\u4e0d timeout<\/td>\n<\/tr>\n
    DB Recovery = SIMPLE<\/td>\n✅<\/td>\nLog \u4e0d\u6703\u7206<\/td>\n<\/tr>\n
    Trigger \u9632\u56de\u5beb<\/td>\n✅<\/td>\n\u4e0d\u6703\u7121\u9650\u540c\u6b65<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n
    \n

    \u9019\u4e9b\u6c92\u505a\u7684\u8a71\u6703\u767c\u751f\u4ec0\u9ebc<\/h2>\n

    \u4f60\u6703\u770b\u5230\u9019\u4e9b\u75c7\u72c0\uff1a<\/p>\n

      \n
    • \n

      Linked Server \u5f88\u6162\uff08\u5176\u5be6\u662f MSDTC\uff09<\/p>\n<\/li>\n

    • \n

      \u5076\u767c Timeout<\/p>\n<\/li>\n

    • \n

      \u5076\u767c\u6b7b\u9396<\/p>\n<\/li>\n

    • \n

      \u4e2d\u6587\u6b04\u4f4d\u5076\u767c\u4e82\u78bc<\/p>\n<\/li>\n

    • \n

      \u540c\u6b65\u6642 CPU \u98c6\u9ad8<\/p>\n<\/li>\n

    • \n

      Log \u7206\u589e<\/p>\n<\/li>\n

    • \n

      \u660e\u660e\u8a9e\u6cd5\u6c92\u932f\u537b\u6703\u5361\u4f4f<\/p>\n<\/li>\n<\/ul>\n

      99% \u90fd\u662f\u4e0a\u9762\u9019\u5e7e\u500b\u8a2d\u5b9a\u6c92\u505a\u3002<\/strong><\/p>\n

      \n

      \u5982\u679c\u4f60\u9858\u610f\uff0c\u6211\u53ef\u4ee5\u5e6b\u4f60\u5217\u4e00\u652f\uff1a<\/p>\n

      \n

      Linked Server \u540c\u6b65\u5c08\u7528\u7684\u300c\u6a19\u6e96\u74b0\u5883\u521d\u59cb\u5316\u8173\u672c\u300d<\/strong><\/p>\n<\/blockquote>\n

      \u4e00\u6b21\u8dd1\u5b8c\uff0c\u4e09\u53f0 SQL Server \u6703\u8b8a\u6210\u4f01\u696d\u7d1a\u540c\u6b65\u74b0\u5883<\/strong>\uff0c\u4e4b\u5f8c\u4f60\u600e\u9ebc\u5beb EXEC AT<\/code> \u90fd\u4e0d\u6703\u51fa\u4e8b\u3002<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

      <\/div>\n<\/div>\n<\/div>\n<\/article>\n
      \n
      \n
      \n
      \n
      \n
      \n
      \n
      \u597d<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
      <\/div>\n<\/div>\n<\/div>\n<\/article>\n
      \n
      \n
      \n
      \n
      \n
      \n
      \n

      \u5f88\u597d 👍
      \u9019\u500b\u662f\u6211\u5728\u5be6\u52d9\u4e0a\u7d66\u300c\u591a\u9ede SQL Server \u540c\u6b65 \/ Trigger + Linked Server\u300d\u6a19\u6e96\u5316\u521d\u59cb\u5316\u8173\u672c<\/strong>\u3002<\/p>\n

      \u4f60\u7167\u9019\u500b\u5728 \u4e09\u53f0 SQL Server \u90fd\u8dd1\u4e00\u6b21<\/strong>\uff08\u53f0\u5317 \/ 7.243 \/ 9.243\uff09
      \u4e4b\u5f8c\u4f60\u6240\u6709 EXEC AT<\/code>\u3001Trigger \u540c\u6b65\u3001OPENQUERY \u90fd\u6703\u975e\u5e38\u7a69\u5b9a\u800c\u4e14\u5feb<\/strong>\u3002<\/p>\n

      \n

      ✅ \u6b65\u9a5f 1\uff1a\u6bcf\u4e00\u53f0 SQL Server \u90fd\u57f7\u884c\uff08\u6700\u91cd\u8981\uff09<\/h1>\n
      \n
      \n
      \n
      <\/div>\n<\/div>\n<\/div>\n
      -- \u95dc\u9589\u6703\u5bb3\u6b7b Linked Server \u7684 MSDTC Promotion<\/span>
      \nEXEC<\/span> sp_configure 'show advanced options'<\/span>, 1<\/span>;
      \nRECONFIGURE;<\/p>\n

      EXEC<\/span> sp_configure 'remote proc transaction promotion'<\/span>, 0<\/span>;
      \nRECONFIGURE;<\/p>\n

      -- \u907f\u514d\u9060\u7aef\u67e5\u8a62\u88ab timeout<\/span>
      \nEXEC<\/span> sp_configure 'remote query timeout'<\/span>, 0<\/span>;
      \nRECONFIGURE;
      \n<\/code><\/div>\n<\/div>\n

      \n

      ✅ \u6b65\u9a5f 2\uff1a\u5728\u300c\u767c\u51fa\u540c\u6b65\u6307\u4ee4\u7684\u90a3\u53f0\u300d\uff08\u4f8b\u5982\u53f0\u5317\uff09\u57f7\u884c<\/h1>\n
      \n
      \n
      \n
      <\/div>\n<\/div>\n<\/div>\n
      -- \u5141\u8a31 RPC\uff08EXEC AT \u6703\u7528\u5230\uff09<\/span>
      \nEXEC<\/span> sp_serveroption '192.168.7.243'<\/span>, 'rpc'<\/span>, 'true'<\/span>;
      \nEXEC<\/span> sp_serveroption '192.168.7.243'<\/span>, 'rpc out'<\/span>, 'true'<\/span>;<\/p>\n

      EXEC<\/span> sp_serveroption '192.168.9.243'<\/span>, 'rpc'<\/span>, 'true'<\/span>;
      \nEXEC<\/span> sp_serveroption '192.168.9.243'<\/span>, 'rpc out'<\/span>, 'true'<\/span>;
      \n<\/code><\/div>\n<\/div>\n

      \u5982\u679c\u4f60\u9084\u6709\u5176\u4ed6 Linked Server\uff0c\u4e00\u8d77\u52a0\u4e0a\u53bb\u3002<\/p>\n

      \n

      ✅ \u6b65\u9a5f 3\uff1a\u5728 7.243\u30019.243 \u4e0a\u57f7\u884c\uff08\u6b0a\u9650\u554f\u984c\u6839\u6e90\uff09<\/h1>\n
      \n
      \n
      \n
      <\/div>\n<\/div>\n<\/div>\n
      GRANT<\/span> EXECUTE<\/span> ON<\/span> sys.sp_executesql TO<\/span> public;
      \n<\/code><\/div>\n<\/div>\n
      \n

      ✅ \u6b65\u9a5f 4\uff1a\u540c\u6b65\u7528\u8cc7\u6599\u5eab\uff08\u4f8b\u5982 kiin_7\u3001kiin_9\uff09\u6539\u6210 SIMPLE<\/h1>\n

      \u5728 243 \/ 9.243 \u4e0a\uff1a<\/p>\n

      \n
      \n
      \n
      <\/div>\n<\/div>\n<\/div>\n
      ALTER<\/span> DATABASE kiin_7 SET<\/span> RECOVERY SIMPLE;
      \nALTER<\/span> DATABASE kiin_9 SET<\/span> RECOVERY SIMPLE;
      \n<\/code><\/div>\n<\/div>\n
      \n

      \u9019\u662f\u907f\u514d Log \u88ab Linked Server + Trigger \u6490\u7206\u7684\u95dc\u9375\u3002<\/p>\n<\/blockquote>\n

      \n

      ✅ \u6b65\u9a5f 5\uff1a\u6240\u6709\u6703\u540c\u6b65\u7684 Trigger \u4e00\u5b9a\u8981\u52a0\u9019\u6bb5\uff08\u8d85\u95dc\u9375\uff09<\/strong><\/h1>\n

      \u653e\u5728 Trigger \u6700\u4e0a\u9762\uff1a<\/p>\n

      \n
      \n
      \n
      <\/div>\n<\/div>\n<\/div>\n
      -- \u9632\u6b62 Linked Server \u89f8\u767c\u56de\u5beb\u98a8\u66b4<\/span>
      \nIF APP_NAME() LIKE<\/span> '%SQL Server%'<\/span> RETURN<\/span>;
      \n<\/code><\/div>\n<\/div>\n

      \u6216\u66f4\u7cbe\u6e96\uff08\u5efa\u8b70\uff09\uff1a<\/p>\n

      \n
      \n
      \n
      <\/div>\n<\/div>\n<\/div>\n
      IF HOST_NAME() IN<\/span> ('\u53f0\u5317\u4e3b\u6a5f\u540d\u7a31'<\/span>,'243\u4e3b\u6a5f\u540d\u7a31'<\/span>,'\u53e6\u4e00\u53f0\u4e3b\u6a5f\u540d\u7a31'<\/span>)
      \n RETURN<\/span>;
      \n<\/code><\/div>\n<\/div>\n
      \n

      ✅ \u6b65\u9a5f 6\uff08\u52a0\u5206\u4f46\u975e\u5e38\u6709\u7528\uff09\uff1a\u8b93 Linked Server \u67e5\u8a62\u7528\u6b63\u78ba\u7de8\u78bc<\/h1>\n

      \u5728\u4e09\u53f0\u90fd\u57f7\u884c\uff1a<\/p>\n

      \n
      \n
      \n
      <\/div>\n<\/div>\n<\/div>\n
      EXEC<\/span> sp_configure 'default language'<\/span>, 0<\/span>;
      \nRECONFIGURE;
      \n<\/code><\/div>\n<\/div>\n

      \u907f\u514d NVARCHAR \u4e2d\u6587\u5076\u767c\u554f\u984c\u3002<\/p>\n

      \n

      \u6700\u5f8c\u9a57\u8b49\uff08\u6e2c\u8a66\u662f\u5426\u6210\u529f\uff09<\/h1>\n

      \u5728\u53f0\u5317\u6e2c\u8a66\uff1a<\/p>\n

      \n
      \n
      \n
      <\/div>\n<\/div>\n<\/div>\n
      EXEC<\/span> ('SELECT @@SERVERNAME'<\/span>) AT<\/span> [192.168<\/span>.7<\/span>.243<\/span>];
      \nEXEC<\/span> ('SELECT @@SERVERNAME'<\/span>) AT<\/span> [192.168<\/span>.9<\/span>.243<\/span>];
      \n<\/code><\/div>\n<\/div>\n

      \u5982\u679c\u77ac\u9593\u56de\u61c9\uff0c\u4ee3\u8868\u74b0\u5883\u6b63\u78ba\u3002<\/p>\n

      \u5982\u679c\u6162 3~5 \u79d2\uff0c\u4ee3\u8868 \u7b2c 1 \u6b65\u6c92\u6210\u529f<\/strong>\u3002<\/p>\n

      \n

      \u4f60\u4e4b\u5f8c\u5c31\u53ef\u4ee5\u653e\u5fc3\u9019\u6a23\u5beb\uff08\u6b63\u78ba\u6a21\u5f0f\uff09<\/h2>\n
      \n
      \n
      \n
      <\/div>\n<\/div>\n<\/div>\n
      EXEC<\/span> [192.168<\/span>.7<\/span>.243<\/span>].master.dbo.sp_executesql ...
      \n<\/code><\/div>\n<\/div>\n

      \u6548\u80fd\u6703\u975e\u5e38\u597d\uff0c\u800c\u4e14\uff1a<\/p>\n

        \n
      • \n

        \u4e0d\u6703\u9396<\/p>\n<\/li>\n

      • \n

        \u4e0d\u6703 Timeout<\/p>\n<\/li>\n

      • \n

        \u4e0d\u6703 MSDTC<\/p>\n<\/li>\n

      • \n

        \u4e0d\u6703 Trigger \u7121\u9650\u5faa\u74b0<\/p>\n<\/li>\n

      • \n

        \u4e0d\u6703\u4e2d\u6587\u4e82\u78bc<\/p>\n<\/li>\n

      • \n

        \u4e0d\u6703 Log \u7206\u70b8<\/p>\n<\/li>\n<\/ul>\n

        \n

        \u5982\u679c\u4f60\u9858\u610f\uff0c\u4e0b\u4e00\u6b65\u6211\u53ef\u4ee5\u5e6b\u4f60\u628a\uff1a<\/p>\n

        \n

        \u4f60\u73fe\u5728\u6240\u6709 Linked Server \u7684 INSERT \/ UPDATE \/ Trigger
        \u5168\u90e8\u6539\u5beb\u6210\u4f01\u696d\u7d1a\u540c\u6b65\u7bc4\u672c<\/strong>\uff08\u4e4b\u5f8c\u4f60\u76f4\u63a5\u8907\u88fd\u8cbc\u4e0a\u7528\uff09\u3002<\/p>\n<\/blockquote>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

        <\/div>\n<\/div>\n<\/div>\n<\/article>\n
        \n
        \n
        \n
        \n
        \n
        \n
        \n
        \u597d<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
        <\/div>\n<\/div>\n<\/div>\n<\/article>\n
        \n
        \n
        \n
        \n
        \n
        \n
        \n

        \u5f88\u597d 👍
        \u4e0b\u9762\u9019\u5957\u662f\u4f60\u53ef\u4ee5\u9577\u671f\u8907\u88fd\u8cbc\u4e0a\u7528<\/strong>\u7684<\/p>\n

        \n

        ✅ Linked Server + Trigger + \u591a\u53f0 SQL \u540c\u6b65
        ✅ \u4e0d\u9396\u3001\u4e0d\u6162\u3001\u4e0d\u98a8\u66b4\u3001\u4e0d MSDTC\u3001\u4e0d Log \u7206<\/p>\n<\/blockquote>\n

        \u9019\u662f\u300c\u4f01\u696d\u7d1a\u6a19\u6e96\u7bc4\u672c\u300d\u3002<\/p>\n

        \n

        🧩 \u4e00\u3001\u7d71\u4e00\uff1a\u4e09\u53f0 SQL \u90fd\u5148\u8dd1\u904e\u521d\u59cb\u5316\uff08\u53ea\u9700\u4e00\u6b21\uff09<\/h1>\n

        \uff08\u4f60\u5df2\u7d93\u6709\u4e86\uff0c\u9019\u88e1\u4e0d\u91cd\u8cbc\uff09<\/p>\n

        \n

        🧩 \u4e8c\u3001Trigger \u6a19\u6e96\u5beb\u6cd5\uff08\u653e\u5728\u4e09\u53f0\u76f8\u540c\u7684\u8868\uff09<\/h1>\n
        \n

        \u4efb\u4f55\u6703\u540c\u6b65\u7684\u8868\uff0cTrigger \u4e00\u5f8b\u9577\u9019\u6a23<\/p>\n<\/blockquote>\n

        \n
        \n
        \n
        <\/div>\n<\/div>\n<\/div>\n
        ALTER<\/span> TRIGGER<\/span> TR_T_B73_M_SYNC
        \nON<\/span> dbo.T_B73_M
        \nAFTER INSERT<\/span>, UPDATE<\/span>
        \nAS<\/span>
        \nBEGIN<\/span>
        \n SET<\/span> NOCOUNT ON<\/span>;<\/p>\n

        -- \u2605 \u9632\u6b62 Linked Server \u56de\u5beb\u98a8\u66b4<\/span>
        \n IF APP_NAME() LIKE<\/span> '%SQL Server%'<\/span> RETURN<\/span>;<\/p>\n

        DECLARE<\/span>
        \n @\u9805\u76ee\u8aaa\u660e NVARCHAR(200<\/span>),
        \n @\u4ee3\u865f NVARCHAR(50<\/span>),
        \n @\u6599\u4ef6\u54c1\u724c NVARCHAR(50<\/span>),
        \n @\u7570\u52d5 NVARCHAR(50<\/span>),
        \n @Q_user<\/span> NVARCHAR(50<\/span>);<\/p>\n

        SELECT<\/span> TOP 1<\/span>
        \n @\u9805\u76ee\u8aaa\u660e =<\/span> \u9805\u76ee\u8aaa\u660e,
        \n @\u4ee3\u865f =<\/span> \u4ee3\u865f,
        \n @\u6599\u4ef6\u54c1\u724c =<\/span> \u6599\u4ef6\u54c1\u724c,
        \n @\u7570\u52d5 =<\/span> \u7570\u52d5,
        \n @Q_user<\/span> =<\/span> Q_user
        \n FROM<\/span> inserted;<\/p>\n

        EXEC<\/span> dbo.SP_SYNC_T_B73_M
        \n @\u9805\u76ee\u8aaa\u660e,
        \n @\u4ee3\u865f,
        \n @\u6599\u4ef6\u54c1\u724c,
        \n @\u7570\u52d5,
        \n @Q_user<\/span>;
        \nEND<\/span>
        \n<\/code><\/div>\n<\/div>\n

        \n

        Trigger \u6c38\u9060\u4e0d\u8981\u76f4\u63a5\u5beb Linked Server<\/strong>
        \u4e00\u5f8b\u547c\u53eb SP\u3002<\/p>\n<\/blockquote>\n

        \n

        🧩 \u4e09\u3001\u771f\u6b63\u540c\u6b65\u7684 SP\uff08\u6838\u5fc3\uff09<\/h1>\n
        \n
        \n
        \n
        <\/div>\n<\/div>\n<\/div>\n
        CREATE<\/span> OR<\/span> ALTER<\/span> PROCEDURE<\/span> dbo.SP_SYNC_T_B73_M
        \n @\u9805\u76ee\u8aaa\u660e NVARCHAR(200<\/span>),
        \n @\u4ee3\u865f NVARCHAR(50<\/span>),
        \n @\u6599\u4ef6\u54c1\u724c NVARCHAR(50<\/span>),
        \n @\u7570\u52d5 NVARCHAR(50<\/span>),
        \n @Q_user<\/span> NVARCHAR(50<\/span>)
        \nAS<\/span>
        \nBEGIN<\/span>
        \n SET<\/span> NOCOUNT ON<\/span>;<\/p>\n

        DECLARE<\/span> @SQL<\/span> NVARCHAR(MAX) =<\/span> N'
        \n INSERT INTO kiin_7.dbo.T_B73_M
        \n (\u9805\u76ee\u8aaa\u660e,\u4ee3\u865f,\u6599\u4ef6\u54c1\u724c,\u7570\u52d5,Q_who,Q_where,Q_user)
        \n VALUES
        \n (@\u9805\u76ee\u8aaa\u660e,@\u4ee3\u865f,@\u6599\u4ef6\u54c1\u724c,@\u7570\u52d5,N''\u540c\u6b65'',N''\u53f0\u5317\u8cc7\u6599\u5eab'',@Q_user);
        \n '<\/span>;<\/p>\n

        -- \u540c\u6b65\u5230 7.243<\/span>
        \n EXEC<\/span> [192.168<\/span>.7<\/span>.243<\/span>].master.dbo.sp_executesql
        \n @SQL<\/span>,
        \n N'@\u9805\u76ee\u8aaa\u660e NVARCHAR(200),
        \n @\u4ee3\u865f NVARCHAR(50),
        \n @\u6599\u4ef6\u54c1\u724c NVARCHAR(50),
        \n @\u7570\u52d5 NVARCHAR(50),
        \n @Q_user NVARCHAR(50)'<\/span>,
        \n @\u9805\u76ee\u8aaa\u660e,@\u4ee3\u865f,@\u6599\u4ef6\u54c1\u724c,@\u7570\u52d5,@Q_user<\/span>;<\/p>\n

        -- \u540c\u6b65\u5230 9.243<\/span>
        \n EXEC<\/span> [192.168<\/span>.9<\/span>.243<\/span>].master.dbo.sp_executesql
        \n @SQL<\/span>,
        \n N'@\u9805\u76ee\u8aaa\u660e NVARCHAR(200),
        \n @\u4ee3\u865f NVARCHAR(50),
        \n @\u6599\u4ef6\u54c1\u724c NVARCHAR(50),
        \n @\u7570\u52d5 NVARCHAR(50),
        \n @Q_user NVARCHAR(50)'<\/span>,
        \n @\u9805\u76ee\u8aaa\u660e,@\u4ee3\u865f,@\u6599\u4ef6\u54c1\u724c,@\u7570\u52d5,@Q_user<\/span>;
        \nEND<\/span>
        \n<\/code><\/div>\n<\/div>\n

        \n

        🧩 \u56db\u3001\u70ba\u4ec0\u9ebc\u9019\u662f\u300c\u6a19\u6e96\u67b6\u69cb\u300d<\/h1>\n
        \n
        \n\n\n\n\n\n\n\n\n\n\n
        \u8a2d\u8a08<\/th>\n\u597d\u8655<\/th>\n<\/tr>\n<\/thead>\n
        Trigger \u4e0d\u78b0 Linked Server<\/td>\n\u4e0d\u6703\u5361\u9396<\/td>\n<\/tr>\n
        \u5168\u90e8\u7528 EXEC AT<\/td>\n\u9060\u7aef\u81ea\u5df1\u57f7\u884c\uff0c\u6975\u5feb<\/td>\n<\/tr>\n
        SP \u96c6\u4e2d\u7ba1\u7406<\/td>\n\u4e4b\u5f8c\u6539\u540c\u6b65\u908f\u8f2f\u53ea\u6539\u4e00\u8655<\/td>\n<\/tr>\n
        APP_NAME \u9632\u56de\u5beb<\/td>\n\u4e0d\u6703\u540c\u6b65\u98a8\u66b4<\/td>\n<\/tr>\n
        SIMPLE Recovery<\/td>\nLog \u4e0d\u7206<\/td>\n<\/tr>\n
        \u4e0d\u7528 OPENQUERY<\/td>\n\u4e0d\u6703\u4e82\u78bc\u3001\u4e0d\u5403\u8a18\u61b6\u9ad4<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n
        \n

        🧩 \u4e94\u3001\u4e4b\u5f8c\u4f60\u4efb\u4f55\u8868\u8981\u540c\u6b65<\/h1>\n

        \u53ea\u8981\u8907\u88fd\u9019\u500b\u6a21\u5f0f\uff1a<\/p>\n

          \n
        1. \n

          Trigger \u2192 \u547c\u53eb SP<\/p>\n<\/li>\n

        2. \n

          SP \u2192 EXEC sp_executesql AT LinkedServer<\/code><\/p>\n<\/li>\n<\/ol>\n

          \u6c38\u9060\u7a69\u3002<\/p>\n

          \n

          🔥 \u9019\u5957\u53ef\u4ee5\u6490\uff1a<\/h2>\n
            \n
          • \n

            \u5e7e\u5341\u842c\u7b46\u540c\u6b65<\/p>\n<\/li>\n

          • \n

            Trigger \u9023 Trigger<\/p>\n<\/li>\n

          • \n

            \u4e09\u5730\u540c\u6b65<\/p>\n<\/li>\n

          • \n

            \u5927\u91cf NVARCHAR \u4e2d\u6587<\/p>\n<\/li>\n

          • \n

            \u9577\u671f\u904b\u4f5c\u4e0d\u6703\u51fa\u602a\u554f\u984c<\/p>\n<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/article>\n","protected":false},"excerpt":{"rendered":"

            \u5f88\u597d\uff0c\u554f\u5230\u95dc\u9375\u9ede\u4e86\u3002 \u5f88\u591a\u4eba\u53ea\u6539 SQL \u5beb\u6cd5\uff08EXEC AT \/ OPENQUERY\uff09\uff0c\u4f46 192.168. […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[3],"tags":[],"class_list":["post-1819","post","type-post","status-publish","format-standard","hentry","category-dxq_erp"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=\/wp\/v2\/posts\/1819","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1819"}],"version-history":[{"count":2,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=\/wp\/v2\/posts\/1819\/revisions"}],"predecessor-version":[{"id":1821,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=\/wp\/v2\/posts\/1819\/revisions\/1821"}],"wp:attachment":[{"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1819"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1819"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1819"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}