{"id":1869,"date":"2015-01-12T12:20:37","date_gmt":"2015-01-12T10:20:37","guid":{"rendered":"http:\/\/soci.hu\/blog\/?p=1869"},"modified":"2015-01-12T12:20:37","modified_gmt":"2015-01-12T10:20:37","slug":"sql-fejtoro-4-megoldas","status":"publish","type":"post","link":"https:\/\/soci.hu\/blog\/index.php\/2015\/01\/12\/sql-fejtoro-4-megoldas\/","title":{"rendered":"SQL fejt\u00f6r\u0151 4. megold\u00e1s"},"content":{"rendered":"<p>Meglep\u0151 m\u00f3don csak 1 megold\u00e1s \u00e9rdekezett erre a <a href=\"http:\/\/soci.hu\/blog\/index.php\/2015\/01\/09\/sql-fejtoro-4\">fejt\u00f6r\u0151re<\/a>, azt hittem egy ez sima gugliz\u00f3s p\u00e9lda lesz.<\/p>\n<p>A p\u00e9ld\u00e1ban egy login trigger volt, ami minden login k\u00eds\u00e9rletet visszautas\u00edt, azaz ezzel kiz\u00e1rhatjuk magunkat is a szerver p\u00e9ld\u00e1nyr\u00f3l, hi\u00e1ba vagyunk sysadminok.<\/p>\n<p>A legegyszer\u0171bb megold\u00e1s ilyenkor a 2005-ben bevezetett <a href=\"http:\/\/technet.microsoft.com\/hu-HU\/library\/ms178068%28v=sql.105%29.aspx\">Dedicated Admin Connection<\/a>. Sim\u00e1n a szerver neve el\u00e9 be kell \u00edrni, hogy ADMIN:, \u00e9s m\u00e1ris be tudunk menni a szerverre, hogy t\u00f6r\u00f6lj\u00fck a triggert.<\/p>\n<p>K\u00f6sz\u00f6n\u00f6m Atcomnak a megold\u00e1st, aki egy m\u00e1sik m\u00f3dszert is le\u00edrt:<br \/>\n&#8220;az SQL Server instanci\u00e1t minim\u00e1lis konfigur\u00e1ci\u00f3s m\u00f3dban ind\u00edtjuk el (<a href=\"http:\/\/technet.microsoft.com\/HU-HU\/library\/ms190737(v=sql.110).aspx\">-f startup option<\/a>), ilyenkor az SQL kiszolg\u00e1l\u00f3 \u201csingle-user\u201d m\u00f3dban ker\u00fcl.&#8221;<\/p>\n<p>Ez m\u00e1r macer\u00e1sabb, ink\u00e1bb ez durv\u00e1bb probl\u00e9m\u00e1kn\u00e1l szoktuk haszn\u00e1lni, de mindenk\u00e9ppen j\u00f3 tudni r\u00f3la.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Meglep\u0151 m\u00f3don csak 1 megold\u00e1s \u00e9rdekezett erre a fejt\u00f6r\u0151re, azt hittem egy ez sima gugliz\u00f3s p\u00e9lda lesz. A p\u00e9ld\u00e1ban egy login trigger&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,4,30],"tags":[],"class_list":["post-1869","post","type-post","status-publish","format-standard","hentry","category-adatbazisok","category-szakmai-elet","category-sql-server"],"_links":{"self":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/1869","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=1869"}],"version-history":[{"count":1,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/1869\/revisions"}],"predecessor-version":[{"id":1871,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/1869\/revisions\/1871"}],"wp:attachment":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=1869"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=1869"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=1869"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}