用SqlServer的事件触发器很少,看到里面有很多的sp_reset_connection语句存在,后来翻看很多网站才找到该进程的名词解释:英文如下
The sp_reset_connection stored procedure is used by SQL Server to support remote stored procedure calls in a transaction.
And its an undocumented stored procedure used internally by SQL Server. It generally shows up when using connection pooling and it is called by SQL Server to reset the connection options/settings before reusing the connection in the connection pool so that the settings don't persist to another client connection.
翻译如下:(自己翻译太生硬了)
sp_reset_connection存储过程常常被SqlServer 在事务中远程调用
它是SqlServer在内使用的扩展存储过程,它通常在SQL Server 使用连接池时显示出来,并且它在重新使用连接池中的连接之前,被SqlServer重启连接设置所调用,以便这个设置不持续到下一个连接。
浙公网安备 33010602011771号