{"id":34772,"date":"2024-09-17T12:08:10","date_gmt":"2024-09-17T10:08:10","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=34772"},"modified":"2024-09-17T12:08:10","modified_gmt":"2024-09-17T10:08:10","slug":"sql-server-the-importance-of-the-default-language-during-a-login-migration","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-the-importance-of-the-default-language-during-a-login-migration\/","title":{"rendered":"SQL Server: The importance of the default language during a login migration"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Few weeks ago, I perform a migration of a database and the associate logins.<br>After few days, the customer contact me for a error about \u201c<strong>conversion of a varchar data type to datetime data type<\/strong>\u201d on this application.<br>The error was an log4net:exception and without more explanation:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"940\" height=\"19\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/09\/image.png\" alt=\"\" class=\"wp-image-34773\" style=\"width:989px;height:auto\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/09\/image.png 940w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/09\/image-300x6.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/09\/image-768x16.png 768w\" sizes=\"auto, (max-width: 940px) 100vw, 940px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">For the migration, I perform a backup\/restore, the collation on both servers is the same and I don\u2019t figure out what is the problem\u2026.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"299\" height=\"303\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/09\/image-7.png\" alt=\"\" class=\"wp-image-34780\" style=\"width:77px;height:auto\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/09\/image-7.png 299w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/09\/image-7-296x300.png 296w\" sizes=\"auto, (max-width: 299px) 100vw, 299px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><br>I searching the difference between both environment with the server configuration, the instance configuration and the database configuration.<br>The last point was the SQL Login configuration and I see that the default language was not the same.<br>The source has <strong>German-Deutsch<\/strong> and destination has <strong>us_english<\/strong> because my login migration script does not take care on the language\u2026.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To be sure to have the answer to this case, I tested it on my lab\u2026<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I create a simple database Test_DefLang &nbsp;and a simple table test with text and datetime datatype:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"933\" height=\"356\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/09\/image-1.png\" alt=\"\" class=\"wp-image-34774\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/09\/image-1.png 933w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/09\/image-1-300x114.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/09\/image-1-768x293.png 768w\" sizes=\"auto, (max-width: 933px) 100vw, 933px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">I create 2 SQL Logins for this databases with the role db_owner.<br>The only difference between both login is the default language:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"939\" height=\"383\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/09\/image-2.png\" alt=\"\" class=\"wp-image-34775\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/09\/image-2.png 939w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/09\/image-2-300x122.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/09\/image-2-768x313.png 768w\" sizes=\"auto, (max-width: 939px) 100vw, 939px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">I connect with the SQL Login Test_DefLang_EN and try different insert with date format:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"939\" height=\"592\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/09\/image-3.png\" alt=\"\" class=\"wp-image-34776\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/09\/image-3.png 939w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/09\/image-3-300x189.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/09\/image-3-768x484.png 768w\" sizes=\"auto, (max-width: 939px) 100vw, 939px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">As you can see in the screenshot, we have 3, the message:<\/p>\n\n\n\n<p class=\"has-vivid-red-color has-text-color has-link-color wp-elements-1 wp-block-paragraph\"><em>Msg 242, Level 16, State 3, Line 7<\/em><\/p>\n\n\n\n<p class=\"has-vivid-red-color has-text-color has-link-color wp-elements-2 wp-block-paragraph\"><em>The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This message comes when the date has a format \u201cdd mm yyyy\u201d with a separator.<br>The format \u201cyyyy mm dd\u201d with the same separator is inserted in the table without problem:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"940\" height=\"653\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/09\/image-4.png\" alt=\"\" class=\"wp-image-34777\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/09\/image-4.png 940w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/09\/image-4-300x208.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/09\/image-4-768x534.png 768w\" sizes=\"auto, (max-width: 940px) 100vw, 940px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Now, I do the test with the German default language Login Test_DefLang_DE with the same insert script:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"939\" height=\"547\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/09\/image-5.png\" alt=\"\" class=\"wp-image-34778\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/09\/image-5.png 939w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/09\/image-5-300x175.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/09\/image-5-768x447.png 768w\" sizes=\"auto, (max-width: 939px) 100vw, 939px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">As you can see with this login (Default Language in German), it\u2019s the opposite here.<br>The error message comes when the date has a format \u201cyyyy mm dd\u201d with a separator.<br>The format \u201cdd mm yyyy\u201d with the same separator is inserted in the table without problem:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"940\" height=\"662\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/09\/image-6.png\" alt=\"\" class=\"wp-image-34779\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/09\/image-6.png 940w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/09\/image-6-300x211.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/09\/image-6-768x541.png 768w\" sizes=\"auto, (max-width: 940px) 100vw, 940px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Now, you see the importance of the default language in simple example and the problem &amp; error that you can have if you don\u2019t take care during a migration.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I hope this experience can help you and now, by dbi services, we adapt our login migration script to be sure to not have this case anymore.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Thanks also to my colleague <a href=\"https:\/\/www.dbi-services.com\/blog\/author\/stevennaudet\/\">Steven Naudet<\/a> for giving me the clue to find the solution to this problem.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Few weeks ago, I perform a migration of a database and the associate logins.After few days, the customer contact me for a error about \u201cconversion of a varchar data type to datetime data type\u201d on this application.The error was an log4net:exception and without more explanation: For the migration, I perform a backup\/restore, the collation on&hellip;&nbsp;<\/p>\n","protected":false},"author":15,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[4133,99],"tags":[49],"class_list":["post-34772","post","type-post","status-publish","format-standard","hentry","category-database","category-sql-server","tag-microsoft"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.4 (Yoast SEO v28.7) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server: The importance of the default language during a login migration - dbi services | Blog<\/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.dbi-services.com\/blog\/sql-server-the-importance-of-the-default-language-during-a-login-migration\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server: The importance of the default language during a login migration\" \/>\n<meta property=\"og:description\" content=\"Few weeks ago, I perform a migration of a database and the associate logins.After few days, the customer contact me for a error about \u201cconversion of a varchar data type to datetime data type\u201d on this application.The error was an log4net:exception and without more explanation: For the migration, I perform a backup\/restore, the collation on&hellip;&nbsp;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-the-importance-of-the-default-language-during-a-login-migration\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi services | Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-09-17T10:08:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/09\/image.png\" \/>\n\t<meta property=\"og:image:width\" content=\"940\" \/>\n\t<meta property=\"og:image:height\" content=\"19\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Haby\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Haby\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-the-importance-of-the-default-language-during-a-login-migration\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-the-importance-of-the-default-language-during-a-login-migration\\\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/7980252d7d7a521e285e7c66114cf82a\"},\"headline\":\"SQL Server: The importance of the default language during a login migration\",\"datePublished\":\"2024-09-17T10:08:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-the-importance-of-the-default-language-during-a-login-migration\\\/\"},\"wordCount\":423,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-the-importance-of-the-default-language-during-a-login-migration\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/image.png\",\"keywords\":[\"Microsoft\"],\"articleSection\":[\"Database\",\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-the-importance-of-the-default-language-during-a-login-migration\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-the-importance-of-the-default-language-during-a-login-migration\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-the-importance-of-the-default-language-during-a-login-migration\\\/\",\"name\":\"SQL Server: The importance of the default language during a login migration - dbi services | Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-the-importance-of-the-default-language-during-a-login-migration\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-the-importance-of-the-default-language-during-a-login-migration\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/image.png\",\"datePublished\":\"2024-09-17T10:08:10+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-the-importance-of-the-default-language-during-a-login-migration\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-the-importance-of-the-default-language-during-a-login-migration\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-the-importance-of-the-default-language-during-a-login-migration\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/image.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/image.png\",\"width\":940,\"height\":19},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-the-importance-of-the-default-language-during-a-login-migration\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server: The importance of the default language during a login migration\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"alternateName\":\"dbi Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\",\"name\":\"dbi services\",\"alternateName\":\"dbi\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialised in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/7980252d7d7a521e285e7c66114cf82a\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than 20 years of experience in Microsoft solutions, specializing in the installation, migration, best practices, and performance analysis of Microsoft SQL Server, as well as Microsoft Business Intelligence solutions (SharePoint, Office) and .NET development for the banking sector. A former Microsoft Most Valuable Professional (MVP) and early adopter of Microsoft Team System in France, he has authored several technical articles. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. His industry experience covers chemicals and pharma, banking, and financial services.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/stephane-haby\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server: The importance of the default language during a login migration - dbi services | Blog","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.dbi-services.com\/blog\/sql-server-the-importance-of-the-default-language-during-a-login-migration\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server: The importance of the default language during a login migration","og_description":"Few weeks ago, I perform a migration of a database and the associate logins.After few days, the customer contact me for a error about \u201cconversion of a varchar data type to datetime data type\u201d on this application.The error was an log4net:exception and without more explanation: For the migration, I perform a backup\/restore, the collation on&hellip;&nbsp;","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-the-importance-of-the-default-language-during-a-login-migration\/","og_site_name":"dbi services | Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2024-09-17T10:08:10+00:00","og_image":[{"width":940,"height":19,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/09\/image.png","type":"image\/png"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-the-importance-of-the-default-language-during-a-login-migration\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-the-importance-of-the-default-language-during-a-login-migration\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7980252d7d7a521e285e7c66114cf82a"},"headline":"SQL Server: The importance of the default language during a login migration","datePublished":"2024-09-17T10:08:10+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-the-importance-of-the-default-language-during-a-login-migration\/"},"wordCount":423,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-the-importance-of-the-default-language-during-a-login-migration\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/09\/image.png","keywords":["Microsoft"],"articleSection":["Database","SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-the-importance-of-the-default-language-during-a-login-migration\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-the-importance-of-the-default-language-during-a-login-migration\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-the-importance-of-the-default-language-during-a-login-migration\/","name":"SQL Server: The importance of the default language during a login migration - dbi services | Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-the-importance-of-the-default-language-during-a-login-migration\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-the-importance-of-the-default-language-during-a-login-migration\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/09\/image.png","datePublished":"2024-09-17T10:08:10+00:00","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-the-importance-of-the-default-language-during-a-login-migration\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-the-importance-of-the-default-language-during-a-login-migration\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-the-importance-of-the-default-language-during-a-login-migration\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/09\/image.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/09\/image.png","width":940,"height":19},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-the-importance-of-the-default-language-during-a-login-migration\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server: The importance of the default language during a login migration"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"alternateName":"dbi Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dbi-services.com\/blog\/#organization","name":"dbi services","alternateName":"dbi","url":"https:\/\/www.dbi-services.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialised in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7980252d7d7a521e285e7c66114cf82a","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than 20 years of experience in Microsoft solutions, specializing in the installation, migration, best practices, and performance analysis of Microsoft SQL Server, as well as Microsoft Business Intelligence solutions (SharePoint, Office) and .NET development for the banking sector. A former Microsoft Most Valuable Professional (MVP) and early adopter of Microsoft Team System in France, he has authored several technical articles. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. His industry experience covers chemicals and pharma, banking, and financial services.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/34772","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=34772"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/34772\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=34772"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=34772"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=34772"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}