2021年8月30日
OLE DB provider "SQLNCLI10" for linked server "x.x.x.x" returned message "No transaction is active.".
摘要： OLE DB provider "SQLNCLI10" for linked server "x.x.x.x" returned message "No transaction is active.". OLE DB provider "SQLNCLI11" for linked server "x 阅读全文
posted @ 2021-08-30 19:04 Insus.NET 阅读(643) 评论(0) 推荐(0)
The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "xxx.xxx.xxx.xxx" was unable to begin a distributed transaction.
摘要： 需要对执行链接数据库时，出现标题异常。那是因为目标数据没有配置好：目标数据打开以下几个选项： EXECUTE sp_configure 'show advanced options',1; GO RECONFIGURE; GO EXECUTE sp_configure 'remote access' 阅读全文
posted @ 2021-08-30 18:55 Insus.NET 阅读(429) 评论(0) 推荐(0)
MS SQL SERVER操作API的GET和POST存储过程
摘要： 上个星期，为了连接DingDing，查找了诸多资料和朋友的指点与帮助。整理好2个存储过程，Get和Post： SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[usp_Util_HttpGet] @Url 阅读全文
posted @ 2021-08-30 11:15 Insus.NET 阅读(751) 评论(0) 推荐(0)