{"id":351,"date":"2007-12-04T09:49:47","date_gmt":"2007-12-04T08:49:47","guid":{"rendered":"http:\/\/soci.hu\/blog\/index.php\/2007\/12\/04\/mit-csinal-az-sp_resetconnection\/"},"modified":"2007-12-04T09:49:47","modified_gmt":"2007-12-04T08:49:47","slug":"mit-csinal-az-sp_resetconnection","status":"publish","type":"post","link":"https:\/\/soci.hu\/blog\/index.php\/2007\/12\/04\/mit-csinal-az-sp_resetconnection\/","title":{"rendered":"Mit csin\u00e1l az sp_resetconnection?"},"content":{"rendered":"<p>Ugye, \u0151 akkor h\u00edv\u00f3dik meg, ha a connection poolb\u00f3l az ADO.NET el\u0151vesz egy haszn\u00e1lt connection-t (\u00e9s, ha nem kapcsoljuk ki :).<\/p>\n<p>Nos, itt a <a href=\"http:\/\/www.sqldev.net\/misc\/sp_reset_connection.htm\">lista<\/a>, mit is csin\u00e1l \u0151:<\/p>\n<p>It resets all error states and numbers (like @@error)<br \/>\nIt stops all EC&#8217;s (execution contexts) that are child threads of a parent EC executing a parallel query<br \/>\nIt will wait for any outstanding I\/O operations that is outstanding<br \/>\nIt will free any held buffers on the server by the connection<br \/>\nIt will unlock any buffer resources that are used by the connection<br \/>\nIt will release all memory allocated owned by the connection<br \/>\nIt will clear any work or temporary tables that are created by the connection<br \/>\nIt will kill all global cursors owned by the connection<br \/>\nIt will close any open SQL-XML handles that are open<br \/>\nIt will delete any open SQL-XML related work tables<br \/>\nIt will close all system tables<br \/>\nIt will close all user tables<br \/>\nIt will drop all temporary objects<br \/>\nIt will abort open transactions<br \/>\nIt will defect from a distributed transaction when enlisted<br \/>\nIt will decrement the reference count for users in current database; which release shared database lock<br \/>\nIt will free acquired locks<br \/>\nIt will releases any handles that may have been acquired<br \/>\nIt will reset all SET options to the default values<br \/>\nIt will reset the @@rowcount value<br \/>\nIt will reset the @@identity value<br \/>\nIt will reset any session level trace options using dbcc traceon()<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ugye, \u0151 akkor h\u00edv\u00f3dik meg, ha a connection poolb\u00f3l az ADO.NET el\u0151vesz egy haszn\u00e1lt connection-t (\u00e9s, ha nem kapcsoljuk ki :). Nos,&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,4,30,21],"tags":[],"class_list":["post-351","post","type-post","status-publish","format-standard","hentry","category-adatbazisok","category-szakmai-elet","category-sql-server","category-sql-server-2005"],"_links":{"self":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/351","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=351"}],"version-history":[{"count":0,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/351\/revisions"}],"wp:attachment":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=351"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=351"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=351"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}