{"id":302,"date":"2013-08-27T01:45:28","date_gmt":"2013-08-27T01:45:28","guid":{"rendered":"http:\/\/www.theSQLReport.com\/?p=302"},"modified":"2014-08-15T10:51:57","modified_gmt":"2014-08-15T10:51:57","slug":"sp_readerrorlog-vs-xp_readerrorlog","status":"publish","type":"post","link":"https:\/\/www.theSQLReport.com\/?p=302","title":{"rendered":"sp_readerrorlog vs xp_readerrorlog"},"content":{"rendered":"

Question: What is the difference between sp_readerrorlog<\/span> and xp_readerrorlog<\/span>?<\/strong><\/p>\n

Executive Summary Answer:<\/strong> ALMOST NOTHING<\/strong><\/p>\n

The More Detailed Answer:<\/strong> under the covers sp_readerrorlog is a stored procedure in the master database that checks that the user is part of the securityadmin group, then calls xp_readerrorlog, passing parameters if available.\u00a0 Any differences between the two procedures does not affect the output, which means the information returned is the same.<\/p>\n

When you run the following for sp_readerrlog:<\/p>\n

sp_helptext N’sp_readerrorlog’<\/span><\/address>\n
go<\/span><\/address>\n

\u00a0The result returned is:<\/p>\n

Text<\/span><\/address>\n
————————————————–<\/span><\/address>\n
create proc sys.sp_readerrorlog(<\/span><\/address>\n
\u00a0\u00a0\u00a0 @p1\u00a0\u00a0\u00a0 int = 0,<\/span><\/address>\n
\u00a0\u00a0\u00a0 @p2\u00a0\u00a0\u00a0 int = NULL,<\/span><\/address>\n
\u00a0\u00a0\u00a0 @p3\u00a0\u00a0\u00a0 nvarchar(4000) = NULL,<\/span><\/address>\n
\u00a0\u00a0\u00a0 @p4\u00a0\u00a0\u00a0 nvarchar(4000) = NULL)<\/span><\/address>\n
as<\/span><\/address>\n
begin<\/span><\/address>\n
\u00a0\u00a0\u00a0\u00a0 if (not is_srvrolemember(N’securityadmin’) = 1)<\/span><\/address>\n
\u00a0\u00a0\u00a0 begin<\/span><\/address>\n
\u00a0\u00a0\u00a0 \u00a0\u00a0 raiserror(15003,-1,-1, N’securityadmin’)<\/span><\/address>\n
\u00a0\u00a0\u00a0 \u00a0\u00a0 return (1)<\/span><\/address>\n
\u00a0\u00a0\u00a0 end<\/span><\/address>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 if (@p2 is NULL)<\/span><\/address>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 exec sys.xp_readerrorlog @p1<\/span><\/address>\n
\u00a0\u00a0\u00a0 else<\/span><\/address>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 exec sys.xp_readerrorlog @p1,@p2,@p3,@p4<\/span><\/address>\n
end<\/span><\/address>\n

\u00a0When you run the following for xp_readerrlog:<\/p>\n

sp_helptext N’xp_readerrorlog’<\/span><\/address>\n
go<\/span><\/address>\n
\u00a0<\/address>\n
The result returned is:<\/address>\n
\"xp_readerrorlog\"<\/address>\n

The\u00a0xpstar.dll library file is a module that stores extended stored procedures for SQL Server.<\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Question: What is the difference between sp_readerrorlog and xp_readerrorlog? Executive Summary Answer: ALMOST NOTHING The More Detailed Answer: under the covers sp_readerrorlog is a stored procedure in the master database … Continue Reading →<\/a><\/p>\n","protected":false},"author":1,"featured_media":308,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-302","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql-server"],"_links":{"self":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/302"}],"collection":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=302"}],"version-history":[{"count":14,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/302\/revisions"}],"predecessor-version":[{"id":727,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/302\/revisions\/727"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/media\/308"}],"wp:attachment":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=302"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=302"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=302"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}