{"id":2292,"date":"2012-10-04T04:53:15","date_gmt":"2012-10-04T04:53:15","guid":{"rendered":"http:\/\/enjoyasp.net\/?p=2292"},"modified":"2012-10-04T04:53:15","modified_gmt":"2012-10-04T04:53:15","slug":"%e6%9f%a5%e7%9c%8bsqlserver%e5%90%af%e5%8a%a8%e5%90%8e%e5%af%b9%e8%b1%a1%e7%9a%84%e6%9b%b4%e6%94%b9","status":"publish","type":"post","link":"https:\/\/enjoyasp.net\/index.php\/2012\/10\/04\/%e6%9f%a5%e7%9c%8bsqlserver%e5%90%af%e5%8a%a8%e5%90%8e%e5%af%b9%e8%b1%a1%e7%9a%84%e6%9b%b4%e6%94%b9\/","title":{"rendered":"\u67e5\u770bsqlserver\u542f\u52a8\u540e\u5bf9\u8c61\u7684\u66f4\u6539"},"content":{"rendered":"<div>\n<pre class=\"brush:sql;first-line:1;pad-line-numbers:true;highlight:null;collapse:false;\">\r\n\r\nselect e.name as eventclass,t.loginname, t.spid, t.starttime, \r\nt.textdata, t.objectid, t.objectname, t.databasename, \r\nt.hostname, t.ntusername, \r\nt.ntdomainname, t.clientprocessid, t.applicationname, t.error \r\nFROM sys.fn_trace_gettable(CONVERT(VARCHAR(150), ( SELECT TOP 1\r\nf.[value]\r\nFROM sys.fn_trace_getinfo(NULL) f --\u627e\u5230\u65e5\u5fd7\u8868\r\nWHERE f.property = 2\r\n)), DEFAULT) T\r\ninner join sys.trace_events e on t.eventclass = e.trace_event_id\r\nwhere eventclass IN(47,164) --47:OBJECT DELETE, 163 OBJECT ALTER\r\n\r\n\r\n --returns full list of events \r\nSELECT *  FROM sys.trace_events\r\n\r\n--returns a full list of categories \r\nSELECT * FROM sys.trace_categories\r\n\r\n\r\n--returns a full list of subclass values\r\nSELECT *FROM sys.trace_subclass_values\r\n\r\nSELECT TOP 50 *\r\nFROM sys.fn_trace_getinfo(NULL)\r\n\r\n<\/pre>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>select e.name as eventclass,t.loginname, t.spid, t.star [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36],"tags":[],"class_list":["post-2292","post","type-post","status-publish","format-standard","hentry","category-sql-server"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2292","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/comments?post=2292"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2292\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=2292"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=2292"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=2292"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}