{"description":"SQL Server 2008 \u3067\u30a8\u30e9\u30fc \u30ed\u30b0\uff08\u7ba1\u7406\u30d5\u30a9\u30eb\u30c0\u306e SQL Server \u30ed\u30b0\uff09\u3092 Transact-SQL \u304b\u3089\u8aad\u307f\u53d6\u308b\u306b\u306f\u3001\u6b21\u306e\u3088\u3046\u306b xp_ReadErrorLog \u62e1\u5f35\u30b9\u30c8\u30a2\u30c9 \u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u3092\u5229\u7528\u3057\u307e\u3059\u3002 xp_ReadErrorLog \u307e\u305f\u306f xp_ReadErrorLog 0,1 \u7b2c1\u5f15\u6570\u306e 0 \u306f\u73fe\u5728\u306e\u30ed\u30b0\u30011 \u306f SQL Server \u306e\u30ed\u30b0\u3068\u3044\u3046\u610f\u5473\u3067\u3059\u3002\u30a2\u30fc\u30ab\u30a4\u30d6\u306e 1\u3064\u76ee\u306e\u30ed\u30b0\u3092\u8aad\u307f\u53d6\u308a\u305f\u3044\u5834\u5408\u306f\u300cxp_ReadErrorLog 1,1\u300d\u3068\u5b9f\u884c\u3057\u307e\u3059\u3002 \u7b2c2\u5f15\u6570\u306f 2 \u3092\u6307\u5b9a\u3059\u308b\u3053\u3068\u3067\u3001SQL Server Agent \u30ed\u30b0\u3092\u8aad\u307f\u53d6\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002 \u305f\u3060\u3057\u3001\u2026","height":"190","published":"2009-11-15 23:20:43","provider_url":"https://hatena.blog","width":"100%","blog_title":"matu_tak\u2019s blog","author_name":"matu_tak","image_url":null,"categories":["SQL Server 2008"],"provider_name":"Hatena Blog","type":"rich","title":"SQL Server \u3067\u30a8\u30e9\u30fc \u30ed\u30b0\u3092\u8aad\u307f\u53d6\u308b\u306b\u306f","url":"https://matutak.hatenablog.com/entry/20091115/1258208443","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fmatutak.hatenablog.com%2Fentry%2F20091115%2F1258208443\" title=\"SQL Server \u3067\u30a8\u30e9\u30fc \u30ed\u30b0\u3092\u8aad\u307f\u53d6\u308b\u306b\u306f - matu_tak\u2019s blog\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","version":"1.0","blog_url":"https://matutak.hatenablog.com/","author_url":"https://blog.hatena.ne.jp/matu_tak/"}