{"id":13255,"date":"2016-09-23T11:51:05","date_gmt":"2016-09-23T11:51:05","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=13255"},"modified":"2016-09-23T11:51:05","modified_gmt":"2016-09-23T11:51:05","slug":"how-to-modify-sql-logging-level-of-crm-from-registry","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/09\/23\/how-to-modify-sql-logging-level-of-crm-from-registry\/","title":{"rendered":"How to modify SQL Logging Level of CRM from Registry"},"content":{"rendered":"

As we know CRM logs plays a vital role in identifying the cause of any errors and act as helping hand for implementers and developers. User can check logs which are divided into different categories such as SQL Logs, .Net Logs, System logs and so on. Along with this different logging level can be defined to know the exact error in CRM functioning.<\/p>\n

New Stuff:\u00a0<\/em><\/strong>How to create on screen Notification Escalation for custom entity.<\/a><\/span><\/span><\/p>\n

It is recommended to keep the logging level either \u201c0\u201d<\/strong> as it will not hamper the CRM operations and on other hand it will keep on adding basic level of logs. Here comes a scenario where screen crashing issue is being reported by user and SQL logging level is set to \u201c0\u201d.<\/strong><\/p>\n

Also, user does not have admin access to CRM but needs to know the reason for the same. So, the alternate way to change the SQL logging level would be from windows Registry<\/strong>. Refer below link to see how to access Sage CRM<\/a> node in registry.
\nWays to Replace Sage CRM License Key<\/a>
\n\"IMG1\"<\/a>
\nSo, once you are at the above path you can see the configured SQL Logging level of your instance. Basically, there are level which can be modified here in form of numerical values.
\nSQL Logging Level:<\/strong>
\n\u2022 Off<\/strong> \u2013 0 it means nothing will be logged by system.
\n\u2022 Errors Only<\/strong>– 1 it means SQL related errors if any will be logged by system.
\n\u2022 All queries over the threshold<\/strong> – 3 it means all the queries will be logged by system.
\nAfter making changes is it recommended to give an IISRESET to bring the change into effect.
\nAlso Read:<\/em><\/strong><\/span>
\n1.<\/strong> User Configurations in Sage CRM<\/a>
\n2.<\/strong> Setting Time Zone configurations in Sage CRM at user level as well as at system level<\/a>
\n3.<\/strong> Pipeline failure with regional currency configurations<\/a>
\n4.<\/strong> Web Service Configurations in Sage CRM<\/a>
\n5.<\/strong> Permissions To Modify The CRM Configurations<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

As we know CRM logs plays a vital role in identifying the cause of any errors and act as helping hand for implementers and developers. User can check logs which are divided into different categories such as SQL Logs, .Net Logs, System logs and so on. Along with this different logging level can be defined\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[73,315,332,380,1],"tags":[544,822,823,1096,1895,1898,2330,2331,2332],"class_list":["post-13255","post","type-post","status-publish","format-standard","hentry","category-configuration","category-registry","category-sage-crm","category-sql","category-uncategorized","tag-all-queries","tag-crm-sql-errors","tag-crm-sql-logs","tag-errors-only","tag-regedit","tag-registry","tag-sql-logging","tag-sql-logging-level","tag-sql-logs"],"yoast_head":"\nHow to modify SQL Logging Level of CRM from Registry - Sage CRM \u2013 Tips, Tricks and Components<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/09\/23\/how-to-modify-sql-logging-level-of-crm-from-registry\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to modify SQL Logging Level of CRM from Registry - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"As we know CRM logs plays a vital role in identifying the cause of any errors and act as helping hand for implementers and developers. User can check logs which are divided into different categories such as SQL Logs, .Net Logs, System logs and so on. Along with this different logging level can be defined\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/09\/23\/how-to-modify-sql-logging-level-of-crm-from-registry\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2016-09-23T11:51:05+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/09\/IMG1.jpg\" \/>\n<meta name=\"author\" content=\"greysagecrm\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagecrm\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/09\/23\/how-to-modify-sql-logging-level-of-crm-from-registry\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/09\/23\/how-to-modify-sql-logging-level-of-crm-from-registry\/\",\"name\":\"How to modify SQL Logging Level of CRM from Registry - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/09\/23\/how-to-modify-sql-logging-level-of-crm-from-registry\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/09\/23\/how-to-modify-sql-logging-level-of-crm-from-registry\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/09\/IMG1.jpg\",\"datePublished\":\"2016-09-23T11:51:05+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/09\/23\/how-to-modify-sql-logging-level-of-crm-from-registry\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/09\/23\/how-to-modify-sql-logging-level-of-crm-from-registry\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/09\/23\/how-to-modify-sql-logging-level-of-crm-from-registry\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/09\/IMG1.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/09\/IMG1.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/09\/23\/how-to-modify-sql-logging-level-of-crm-from-registry\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to modify SQL Logging Level of CRM from Registry\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\",\"name\":\"Sage CRM \u2013 Tips, Tricks and Components\",\"description\":\"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\",\"name\":\"greysagecrm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"greysagecrm\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to modify SQL Logging Level of CRM from Registry - Sage CRM \u2013 Tips, Tricks and Components","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:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/09\/23\/how-to-modify-sql-logging-level-of-crm-from-registry\/","og_locale":"en_US","og_type":"article","og_title":"How to modify SQL Logging Level of CRM from Registry - Sage CRM \u2013 Tips, Tricks and Components","og_description":"As we know CRM logs plays a vital role in identifying the cause of any errors and act as helping hand for implementers and developers. User can check logs which are divided into different categories such as SQL Logs, .Net Logs, System logs and so on. Along with this different logging level can be defined\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/09\/23\/how-to-modify-sql-logging-level-of-crm-from-registry\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2016-09-23T11:51:05+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/09\/IMG1.jpg","type":"","width":"","height":""}],"author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/09\/23\/how-to-modify-sql-logging-level-of-crm-from-registry\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/09\/23\/how-to-modify-sql-logging-level-of-crm-from-registry\/","name":"How to modify SQL Logging Level of CRM from Registry - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/09\/23\/how-to-modify-sql-logging-level-of-crm-from-registry\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/09\/23\/how-to-modify-sql-logging-level-of-crm-from-registry\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/09\/IMG1.jpg","datePublished":"2016-09-23T11:51:05+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/09\/23\/how-to-modify-sql-logging-level-of-crm-from-registry\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/09\/23\/how-to-modify-sql-logging-level-of-crm-from-registry\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/09\/23\/how-to-modify-sql-logging-level-of-crm-from-registry\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/09\/IMG1.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/09\/IMG1.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/09\/23\/how-to-modify-sql-logging-level-of-crm-from-registry\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"How to modify SQL Logging Level of CRM from Registry"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/","name":"Sage CRM \u2013 Tips, Tricks and Components","description":"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f","name":"greysagecrm","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"greysagecrm"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/13255","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=13255"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/13255\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=13255"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=13255"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=13255"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}