What does sp_reset_connection do
来源:互联网 发布:彩虹六号围攻 mac 编辑:程序博客网 时间:2024/04/20 23:00
sp_reset_connection resets the following aspects of a connection:
It resets all error states and numbers (like @@error)
It stops all EC's (execution contexts) that are child threads of a parent EC executing a parallel query
It will wait for any outstanding I/O operations that is outstanding
It will free any held buffers on the server by the connection
It will unlock any buffer resources that are used by the connection
It will release all memory allocated owned by the connection
It will clear any work or temporary tables that are created by the connection
It will kill all global cursors owned by the connection
It will close any open SQL-XML handles that are open
It will delete any open SQL-XML related work tables
It will close all system tables
It will close all user tables
It will drop all temporary objects
It will abort open transactions
It will defect from a distributed transaction when enlisted
It will decrement the reference count for users in current database; which release shared database lock
It will free acquired locks
It will releases any handles that may have been acquired
It will reset all SET options to the default values
It will reset the @@rowcount value
It will reset the @@identity value
It will reset any session level trace options using dbcc traceon()
sp_reset_connection will NOT reset:
Security context, which is why connection pooling matches connections based on the exact connection string
If you entered an application role using sp_setapprole, since application roles can not be reverted
- What does sp_reset_connection do
- sp_reset_connection是干嘛的?( What does sp_reset_connection do?)
- What does volatile do?
- What does volatile do?
- What does arraycommpath do?
- What does Logrotate do?
- (zz)What does volatile do?
- What does a ScrumMaster do?
- What does Class.forName(); do?
- What does functools.wraps do?
- What does job syspolicy_purge_history do?
- What does functools.wraps do?
- What does functools.wraps do?
- What is 'JNDI'? What does 'JDNI' do?
- What does Class.forname method do?
- What does the SQLERRM Function do
- What does the SQLCODE Function do
- What does the C ??!??! operator do?!
- ubuntu系统VNC服务器安装配置
- 使用javascript的substr实现文字跑马灯
- 数据库数据生成word文档的方法
- 测试并行程序
- python list排序
- What does sp_reset_connection do
- oracle拼音排序
- vim+ctags命令
- 兴趣图谱必将重塑社交网络及电子商务
- 程序员版狂人日记一
- String中matches用法
- matlab DTW语音识别算法调试
- 提升Android应用视觉效果的10个UI技巧
- 双击文件夹为何显示文件属性