{"id":908,"date":"2012-01-27T08:58:30","date_gmt":"2012-01-27T07:58:30","guid":{"rendered":"https:\/\/bob-team.de\/wordpress\/?p=908"},"modified":"2012-01-27T08:58:30","modified_gmt":"2012-01-27T07:58:30","slug":"prozesse-vom-mssql-beenden","status":"publish","type":"post","link":"https:\/\/bob-team.de\/wordpress\/2012\/01\/27\/prozesse-vom-mssql-beenden\/","title":{"rendered":"Prozesse vom MSSQL beenden"},"content":{"rendered":"<p>Das Skript beendet alle Prozesse einer Anwendung f\u00fcr einen bestimmten Benutzer. Dazu wird die Systemtabelle <tt>sysprocesses<\/tt> abgefragt und f\u00fcr jede gefundene PID der Befehl <tt>kill<\/tt> ausgef\u00fchrt.<\/p>\n<p>[code lang=&#8220;sql&#8220;]DECLARE @spid\t int<br \/>\nDECLARE CUR CURSOR FOR<br \/>\n   SELECT spid FROM sysprocesses<br \/>\n      WHERE program_name = &#8218;Name der Anwendung&#8216;<br \/>\n      AND loginame = &#8218;Name des SQL Benutzers&#8216;<br \/>\nOPEN CUR<br \/>\nFETCH NEXT FROM CUR INTO @spid<br \/>\nWHILE @@FETCH_STATUS = 0<br \/>\nBEGIN<br \/>\n   EXECUTE (&#8218;KILL &#8218; + @spid)<br \/>\n   FETCH NEXT FROM CUR INTO @spid<br \/>\nEND<br \/>\nCLOSE CUR<br \/>\nDEALLOCATE CUR[\/code]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Das Skript beendet alle Prozesse einer Anwendung f\u00fcr einen bestimmten Benutzer. Dazu wird die Systemtabelle sysprocesses abgefragt und f\u00fcr jede gefundene PID der Befehl kill ausgef\u00fchrt. [code lang=&#8220;sql&#8220;]DECLARE @spid int DECLARE CUR CURSOR FOR SELECT spid FROM sysprocesses WHERE program_name = &#8218;Name der Anwendung&#8216; AND loginame = &#8218;Name des SQL Benutzers&#8216; OPEN CUR FETCH NEXT [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[72],"class_list":["post-908","post","type-post","status-publish","format-standard","hentry","category-skripte","tag-mssql","entry"],"_links":{"self":[{"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/posts\/908","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/comments?post=908"}],"version-history":[{"count":2,"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/posts\/908\/revisions"}],"predecessor-version":[{"id":910,"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/posts\/908\/revisions\/910"}],"wp:attachment":[{"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/media?parent=908"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/categories?post=908"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/tags?post=908"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}