{"id":6657,"date":"2018-12-17T08:15:05","date_gmt":"2018-12-17T08:15:05","guid":{"rendered":"https:\/\/dbtut.com\/?p=6657"},"modified":"2018-12-17T08:30:21","modified_gmt":"2018-12-17T08:30:21","slug":"how-to-filter-sql-server-error-loglike-or-not-like","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/12\/17\/how-to-filter-sql-server-error-loglike-or-not-like\/","title":{"rendered":"How To Filter SQL Server Error Log(Like or Not Like)"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>The SQL Server Error Log file is one of the first places each DBA looks at in order to understand and solve the problem.<\/p>\n<p>In this article, we will examine the below scenarios.<\/p>\n<ul type=\"disc\">\n<li>How to read the entire Error Log file without a filter<\/li>\n<li>How to read Error Log file by filtering.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>As you can see in the picture below, you can read the Error Log file without a filter.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/886.png\" width=\"481\" height=\"152\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>When the Error Log File opens, you can create a filter by clicking on the Filter as you see below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/732.png\" width=\"378\" height=\"568\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>In the &#8220;Message contains text&#8221; section, type the word you want to search for in the error log file, click &#8220;Apply filter&#8221;, and then click ok.<\/p>\n<p>When we did this, the result was returned as follows.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/824.png\" width=\"528\" height=\"154\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>When the &#8220;Error Log&#8221; file is too complicated, we can filter what we want to see.<\/p>\n<p>Sometimes we need to filter what we don&#8217;t want to see. In this way, you can read the error log file, which is free of unnecessary information.<\/p>\n<p>You can perform this operation with the help of the following script.<\/p>\n<pre class=\"lang:default decode:true\">CREATE TABLE #read_error_log\r\n\u00a0 (\r\n\u00a0\u00a0\u00a0\u00a0 logdate\u00a0\u00a0\u00a0\u00a0\u00a0 DATETIME,\r\n\u00a0\u00a0\u00a0\u00a0 processinfo\u00a0 VARCHAR(200),\r\n\u00a0\u00a0\u00a0\u00a0 errorlogtext VARCHAR(max)\r\n\u00a0 )\r\n\r\nINSERT INTO #read_error_log\r\n\r\nEXEC master.dbo.Xp_readerrorlog\r\n\u00a0 0,\r\n\u00a0 1,\r\n\u00a0 N'',\r\n\u00a0 N'',\r\n\u00a0 '20160922 00:00',\r\n\u00a0 '20160924'\r\n\r\n\r\nSELECT * FROM #read_error_log\r\nwhere errorlogtext not like '%participating in an%' and errorlogtext not like '%Error: 976, Severity: 14, State: 1.%'\r\nand errorlogtext not like '%Log was backed%'\r\nORDER\u00a0 BY logdate DESC\r\n\r\nTRUNCATE TABLE #read_error_log\r\nDROP TABLE #read_error_log\r\n<\/pre>\n<p>&nbsp;<\/p>\n<p>As you can see in the script, the script part of &#8220;<code>EXEC master.dbo.Xp_readerrorlog<\/code>&#8221; is used to read the entire Error Log file.<\/p>\n<p>We have run the above script with many parameters.<\/p>\n<p>Below are the descriptions of these parameters.<\/p>\n<table style=\"height: 540px; width: 652px; border-color: #000000;\" border=\"1\">\n<caption>\u00a0<\/caption>\n<tbody>\n<tr style=\"height: 103px;\">\n<td style=\"width: 125.6px; height: 103px;\"><strong>First Parameter<\/strong> 0<\/td>\n<td style=\"width: 512px; height: 103px;\">This means we&#8217;re reading the current active log file. I recommend that you read the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/12\/15\/how-to-increase-sql-server-error-log-file-count\/\" target=\"_blank\" rel=\"noopener\">How to Increase SQL Server Error Log File Count<\/a>&#8221; about the SQL Server Error Log file count.<\/td>\n<\/tr>\n<tr style=\"height: 79px;\">\n<td style=\"width: 125.6px; height: 79px;\"><strong>Second Parameter<\/strong> 1<\/td>\n<td style=\"width: 512px; height: 79px;\">This means that we have read SQL Server Error Log. If there were 2, we would be reading the SQL Server Agent Error Log.<\/td>\n<\/tr>\n<tr style=\"height: 79px;\">\n<td style=\"width: 125.6px; height: 79px;\"><strong>Third Parameter<\/strong> N&#8221;<\/td>\n<td style=\"width: 512px; height: 79px;\">This is the word we want to filter in the Message part in the Error Log. We did not select this option by typing N &#8221;.<\/td>\n<\/tr>\n<tr style=\"height: 103px;\">\n<td style=\"width: 125.6px; height: 103px;\"><strong>Fourth Parameter<\/strong> N&#8221;<\/td>\n<td style=\"width: 512px; height: 103px;\">Same as the third parameter. If you want to search with more than one word, you set your second filter in this parameter. We did not select this option by typing N &#8221;.<\/td>\n<\/tr>\n<tr style=\"height: 127px;\">\n<td style=\"width: 125.6px; height: 127px;\"><strong>Fifth Parameter<\/strong> &#8216;20160922 00:00&#8217;<\/td>\n<td style=\"width: 512px; height: 127px;\">Starting date.<\/td>\n<\/tr>\n<tr style=\"height: 49px;\">\n<td style=\"width: 125.6px; height: 49px;\"><strong>Sixth Parameter<\/strong> &#8216;20160924&#8217;<\/td>\n<td style=\"width: 512px; height: 49px;\">Finish date.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p>In the rest of the script, you see &#8220;where errorlogtext not like&#8221; statements. We&#8217;re writing the expressions that we don&#8217;t want to see in the log file with these not like expressions.<\/p>\n<p>At the end of the query, you can increase the number of queries that you do not want to see by adding AND NOT LIKE. In this way, we only get an Error Log file that will contain the information we need.<\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_6657\" class=\"pvc_stats all  \" data-element-id=\"6657\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; The SQL Server Error Log file is one of the first places each DBA looks at in order to understand and solve the problem. In this article, we will examine the below scenarios. How to read the entire Error Log file without a filter How to read Error Log file by filtering. &nbsp; As &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_6657\" class=\"pvc_stats all  \" data-element-id=\"6657\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6657","post","type-post","status-publish","format-standard","","category-mssql"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Filter SQL Server Error Log(Like or Not Like) - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Filter SQL Server Error Log(Like or Not Like)\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/12\/17\/how-to-filter-sql-server-error-loglike-or-not-like\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Filter SQL Server Error Log(Like or Not Like) - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Filter SQL Server Error Log(Like or Not Like)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/12\/17\/how-to-filter-sql-server-error-loglike-or-not-like\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-12-17T08:15:05+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-12-17T08:30:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/886.png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/17\/how-to-filter-sql-server-error-loglike-or-not-like\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/17\/how-to-filter-sql-server-error-loglike-or-not-like\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Filter SQL Server Error Log(Like or Not Like)\",\"datePublished\":\"2018-12-17T08:15:05+00:00\",\"dateModified\":\"2018-12-17T08:30:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/17\/how-to-filter-sql-server-error-loglike-or-not-like\/\"},\"wordCount\":449,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/17\/how-to-filter-sql-server-error-loglike-or-not-like\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/886.png\",\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/12\/17\/how-to-filter-sql-server-error-loglike-or-not-like\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/17\/how-to-filter-sql-server-error-loglike-or-not-like\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/17\/how-to-filter-sql-server-error-loglike-or-not-like\/\",\"name\":\"How To Filter SQL Server Error Log(Like or Not Like) - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/17\/how-to-filter-sql-server-error-loglike-or-not-like\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/17\/how-to-filter-sql-server-error-loglike-or-not-like\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/886.png\",\"datePublished\":\"2018-12-17T08:15:05+00:00\",\"dateModified\":\"2018-12-17T08:30:21+00:00\",\"description\":\"How To Filter SQL Server Error Log(Like or Not Like)\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/17\/how-to-filter-sql-server-error-loglike-or-not-like\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/12\/17\/how-to-filter-sql-server-error-loglike-or-not-like\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/17\/how-to-filter-sql-server-error-loglike-or-not-like\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/886.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/886.png\",\"width\":626,\"height\":198},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/17\/how-to-filter-sql-server-error-loglike-or-not-like\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Filter SQL Server Error Log(Like or Not Like)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Filter SQL Server Error Log(Like or Not Like) - Database Tutorials","description":"How To Filter SQL Server Error Log(Like or Not Like)","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2018\/12\/17\/how-to-filter-sql-server-error-loglike-or-not-like\/","og_locale":"en_US","og_type":"article","og_title":"How To Filter SQL Server Error Log(Like or Not Like) - Database Tutorials","og_description":"How To Filter SQL Server Error Log(Like or Not Like)","og_url":"https:\/\/dbtut.com\/index.php\/2018\/12\/17\/how-to-filter-sql-server-error-loglike-or-not-like\/","og_site_name":"Database Tutorials","article_published_time":"2018-12-17T08:15:05+00:00","article_modified_time":"2018-12-17T08:30:21+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/886.png","type":"","width":"","height":""}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/17\/how-to-filter-sql-server-error-loglike-or-not-like\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/17\/how-to-filter-sql-server-error-loglike-or-not-like\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Filter SQL Server Error Log(Like or Not Like)","datePublished":"2018-12-17T08:15:05+00:00","dateModified":"2018-12-17T08:30:21+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/17\/how-to-filter-sql-server-error-loglike-or-not-like\/"},"wordCount":449,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/17\/how-to-filter-sql-server-error-loglike-or-not-like\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/886.png","articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/12\/17\/how-to-filter-sql-server-error-loglike-or-not-like\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/17\/how-to-filter-sql-server-error-loglike-or-not-like\/","url":"https:\/\/dbtut.com\/index.php\/2018\/12\/17\/how-to-filter-sql-server-error-loglike-or-not-like\/","name":"How To Filter SQL Server Error Log(Like or Not Like) - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/17\/how-to-filter-sql-server-error-loglike-or-not-like\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/17\/how-to-filter-sql-server-error-loglike-or-not-like\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/886.png","datePublished":"2018-12-17T08:15:05+00:00","dateModified":"2018-12-17T08:30:21+00:00","description":"How To Filter SQL Server Error Log(Like or Not Like)","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/17\/how-to-filter-sql-server-error-loglike-or-not-like\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/12\/17\/how-to-filter-sql-server-error-loglike-or-not-like\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/17\/how-to-filter-sql-server-error-loglike-or-not-like\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/886.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/886.png","width":626,"height":198},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/17\/how-to-filter-sql-server-error-loglike-or-not-like\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Filter SQL Server Error Log(Like or Not Like)"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/6657","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=6657"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/6657\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=6657"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=6657"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=6657"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}