SQL Server - Microsoft Q&A

<!DOCTYPE html> <html class="layout layout-sidecar-left default-focus" lang="en-us" dir="ltr" data-authenticated="false" data-auth-status-determined="false" data-target="docs" x-ms-format-detection="none" > <head> <title>SQL Server - Microsoft Q&A</title> <meta charset="utf-8" /> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1" /> <meta name="viewport" content="width=device-width, initial-scale=1.0" /> <meta name="color-scheme" content="light dark" /> <meta name="title" content="SQL Server - Microsoft Q&A" /> <meta name="description" content="A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions." /> <link rel="canonical" href="https://learn.microsoft.com/en-us/answers/tags/191/sql-server" />  <meta name="twitter:card" content="summary_large_image" /> <meta name="twitter:site" content="@MicrosoftLearn" /> <meta property="og:type" content="website" /> <meta property="og:image:alt" content="Microsoft Learn" /> <meta property="og:image" content="https://learn.microsoft.com/en-us/media/open-graph-image.png" />  <meta property="og:title" content="SQL Server - Microsoft Q&A" /> <meta property="og:url" content="https://learn.microsoft.com/en-us/answers/tags/191/sql-server" /> <meta property="og:description" content="A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions." /> <meta name="locale" content="en-us" /> <meta name="uhfHeaderId" content="answersv2" /> <meta name="pageType" content="QnA" />    <link rel="stylesheet" href="/static/assets/0.4.028726178/styles/site-ltr.css" /> <script src="https://wcpstatic.microsoft.com/mscc/lib/v2/wcp-consent.js"></script> <script src="https://js.monitor.azure.com/scripts/c/ms.jsll-4.min.js"></script> <script src="/_themes/docs.theme/master/en-us/_themes/global/deprecation.js"></script>  <script id="msdocs-script"> var msDocs = { "environment": { "accessLevel": "online", "azurePortalHostname": "portal.azure.com", "reviewFeatures": false, "supportLevel": "production", "systemContent": true, "siteName": "learn", "legacyHosting": false }, "data": { "contentLocale": "en-us", "contentDir": "ltr", "userLocale": "en-us", "userDir": "ltr", "pageTemplate": "Tag", "brand": "docs", "context": {}, "hasBinaryRating": false, "showFeedbackReport": false, "enableTutorialFeedback": false, "contentGitUrl": "", "extendBreadcrumb": false, "isEditDisplayable": false, "hideViewSource": false, "hasPageActions": false, "hasBookmark": true, "isPermissioned": false, "hasShare": true, "hasRecommendations": false, "openSourceFeedback": false, "openSourceFeedbackIssueUrl": "", "contributors": [] }, "functions": {} };; </script>  <script src="/static/assets/0.4.028726178/scripts/en-us/index-critical-qna.js"></script> <script defer src="/static/assets/0.4.028726178/scripts/en-us/index-qna.js"></script>  </head> <header class="layout-body-header"> <div class="header-holder has-default-focus"> <a href="#main" style="z-index: 1070" class="outline-color-text visually-hidden-until-focused position-fixed inner-focus focus-visible top-0 left-0 right-0 padding-xs text-align-center background-color-body" >Skip to main content</a > <a href="#" data-skip-to-ask-learn style="z-index: 1070" class="outline-color-text visually-hidden-until-focused position-fixed inner-focus focus-visible top-0 left-0 right-0 padding-xs text-align-center background-color-body" hidden >Skip to Ask Learn chat experience</a > <div id="ignite-banner-holder" class="has-default-focus has-overflow-hidden"></div> <div hidden id="cookie-consent-holder" data-test-id="cookie-consent-container"></div>  <div id="unsupported-browser" style="background-color: white; color: black; padding: 16px; border-bottom: 1px solid grey;" hidden > <div style="max-width: 800px; margin: 0 auto;"> <p style="font-size: 24px">This browser is no longer supported.</p> <p style="font-size: 16px; margin-top: 16px;"> Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support. </p> <div style="margin-top: 12px;"> <a href="https://go.microsoft.com/fwlink/p/?LinkID=2092881 " style="background-color: #0078d4; border: 1px solid #0078d4; color: white; padding: 6px 12px; border-radius: 2px; display: inline-block;" > Download Microsoft Edge </a> <a href="https://learn.microsoft.com/en-us/lifecycle/faq/internet-explorer-microsoft-edge" style="background-color: white; padding: 6px 12px; border: 1px solid #505050; color: #171717; border-radius: 2px; display: inline-block;" > More info about Internet Explorer and Microsoft Edge </a> </div> </div> </div>  <header id="ms--site-header" data-test-id="site-header-wrapper" role="banner" itemscope="itemscope" itemtype="http://schema.org/Organization" > <div id="ms--mobile-nav" class="site-header display-none-tablet padding-inline-none gap-none" data-bi-name="mobile-header" data-test-id="mobile-header" ></div> <div id="ms--primary-nav" class="site-header display-none display-flex-tablet" data-bi-name="L1-header" data-test-id="primary-header" ></div> <div id="ms--secondary-nav" class="site-header display-none display-flex-tablet" data-bi-name="L2-header" data-test-id="secondary-header" ></div> </header> </div> </header> <body id="body" data-bi-name="body" class="layout-body "> <section id="layout-body-hero" class="layout-body-hero " data-bi-name="hero" > <section id=tags-hero data-bi-name=tags-hero data-test-id=tags-hero class="hero hero-image hero-xs background-color-body-accent gradient-border-right gradient-border-body-accent" style="--hero-background-image-light: url(/en-us/media/qna/hero/hero-tags-light.jpg?branch=main); --hero-background-image-dark: url(/en-us/media/qna/hero/hero-tags-dark.jpg?branch=main);" > <div class="hero-content"> <div class="display-flex"> <div> <p class="font-size-xs letter-spacing-wide text-transform-uppercase"> Microsoft Q&A </p> <h1 class="title is-2 font-weight-semibold" id="tagHeading" data-tag-id="aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy" > SQL Server </h1> <p>19,528 questions</p> <p class="margin-top-xxs">A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.</p> <div class="buttons margin-top-xs"> <a data-test-id="browse-all-tags-button" class="button has-inner-focus button-clear border" href="/en-us/answers/products/191/sql-server" > Browse all SQL Server tags </a> <button class="not-authenticated button button-primary button-sm button-filled docs-sign-in" data-test-id="sign-in-to-follow-button" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </div> </section> </section> <section id="layout-body-menu" class="layout-body-menu " data-bi-name="menu" > <div class="layout-padding padding-top-xs"> <div class="is-hidden-tablet margin-top-xxs"> <button id="qna-mobile-filter-button" data-test-id="qna-mobile-filter-button" class="button button-clear border button-sm" data-bi-name="qna-mobile-filter-button" > <span class="icon" aria-hidden="true"> <span class="docon docon-filter-settings"></span> </span> <span>Filters</span> </button> </div> <div class="is-hidden-mobile" data-bi-name="qna-filters" data-test-id="qna-tablet-filter-container" > <legend> <h2 class="title is-3">Filter</h2> </legend> <hr class="hr margin-block-xs" /> <div class="margin-bottom-xs border-bottom qna-filters-container"> <h3 class="title is-5 margin-bottom-xs">Content</h3> <div class=""> <fieldset class="field control margin-bottom-xs"> <div class="display-flex flex-direction-column"> <a href="?filterby=null" class="radio text-decoration-none has-text-subtle margin-bottom-xxs padding-none " aria-current="page" data-test-id="answers-question-facet-null" > <div class="display-flex width-full flex-wrap-wrap"> <div class="display-flex"> <span class="radio-dot is-checked" aria-hidden="true"></span> <span class="radio-label-text">All questions</span> </div> <div class="flex-grow-1 text-align-right"> <span class="tag is-small border-radius-rounded is-primary"> 19.5K </span> </div> </div> </a> <a href="?filterby=unanswered" class="radio text-decoration-none has-text-subtle margin-bottom-xxs padding-none " aria-current="false" data-test-id="answers-question-facet-unanswered" > <div class="display-flex width-full flex-wrap-wrap"> <div class="display-flex"> <span class="radio-dot " aria-hidden="true"></span> <span class="radio-label-text">No answers</span> </div> <div class="flex-grow-1 text-align-right"> <span class="tag is-small border-radius-rounded "> 871 </span> </div> </div> </a> <a href="?filterby=answered" class="radio text-decoration-none has-text-subtle margin-bottom-xxs padding-none " aria-current="false" data-test-id="answers-question-facet-answered" > <div class="display-flex width-full flex-wrap-wrap"> <div class="display-flex"> <span class="radio-dot " aria-hidden="true"></span> <span class="radio-label-text">Has answers</span> </div> <div class="flex-grow-1 text-align-right"> <span class="tag is-small border-radius-rounded "> 18.7K </span> </div> </div> </a> <a href="?filterby=withoutengagement" class="radio text-decoration-none has-text-subtle margin-bottom-xxs padding-none " aria-current="false" data-test-id="answers-question-facet-withoutengagement" > <div class="display-flex width-full flex-wrap-wrap"> <div class="display-flex"> <span class="radio-dot " aria-hidden="true"></span> <span class="radio-label-text">No answers or comments</span> </div> <div class="flex-grow-1 text-align-right"> <span class="tag is-small border-radius-rounded "> 152 </span> </div> </div> </a> <a href="?filterby=withacceptedanswer" class="radio text-decoration-none has-text-subtle margin-bottom-xxs padding-none " aria-current="false" data-test-id="answers-question-facet-withacceptedanswer" > <div class="display-flex width-full flex-wrap-wrap"> <div class="display-flex"> <span class="radio-dot " aria-hidden="true"></span> <span class="radio-label-text">With accepted answer</span> </div> <div class="flex-grow-1 text-align-right"> <span class="tag is-small border-radius-rounded "> 7.2K </span> </div> </div> </a> </div> </fieldset> </div> </div> </div> </div> </section> <main id="main" role="main" class="layout-body-main " data-bi-name="content" dir="ltr" > <div class="layout-padding padding-top-xs" data-bi-name="qna-tag-page-content" > <div class="level is-mobile margin-bottom-xxs flex-wrap-wrap"> <div class="level-left"> <div class="level-item"> <h2 class="title is-6"> 19,528 questions with SQL Server-related tags </h2> </div> </div> <div class="level-right"> <details class="popover"> <summary class="button button-clear" data-test-id="sortby-popover-button"> <span >Sort by: <span class="has-text-primary font-weight-semibold"> Updated <span class="icon" aria-hidden="true"> <span class="expanded-indicator docon docon-chevron-down-light"></span> </span> </span></span > </summary> <div class="popover-content padding-none" data-test-id="sortby-menu"> <a aria-label="Sort by: Updated" class="button button-clear has-inner-focus button-block text-decoration-none justify-content-flex-start is-hovered" aria-current=page href="?orderby=updatedat&page=1" data-test-id="sortby-filter-link-updatedat" >Updated</a > <a aria-label="Sort by: Created" class="button button-clear has-inner-focus button-block text-decoration-none justify-content-flex-start " href="?orderby=createdat&page=1" data-test-id="sortby-filter-link-createdat" >Created</a > <a aria-label="Sort by: Answers" class="button button-clear has-inner-focus button-block text-decoration-none justify-content-flex-start " href="?orderby=answercount&page=1" data-test-id="sortby-filter-link-answercount" >Answers</a > </div> </details> </div> </div>  <div class="box margin-bottom-xxs"> <div class="columns is-multiline"> <div class="column is-9-desktop is-12-tablet"> <div class="columns is-mobile "> <div class="column is-narrow has-text-right width-150-tablet"> <span class="has-text-subtle font-size-sm" title="" > 0 answers </span> </div> <div class="column"> <h2 class="title is-6 margin-bottom-xxs"> <a href="/en-us/answers/questions/2122397/how-to-load-data-from-multiple-txt-files-after-rem"> How to load data from multiple txt files after removing first row into tables? </a> </h2> <p class="has-text-wrap">Hi All, I faced one scenario where i have 6 txt files of different regions. In every text document First Line is not required. How can I remove First line alone and load the data from all six source docs into SQL tables? Data From North…</p> <div class="tags margin-top-xxs"> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-sql-server-intergration-services"> <span>SQL Server Integration Services</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-sql-server-intergration-services" data-bi-name="tag-card-link" href="/en-us/answers/tags/253/sql-server-intergration-services/" > SQL Server Integration Services </a> <div class="card-content-description" data-test-id="tag-card-description"> A Microsoft platform for building enterprise-level data integration and data transformations solutions. </div> </div> <div class="card-template"> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-sql-server-intergration-services"> 2,601 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-sql-server-intergration-services" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9taWNyb3NvZnQtZGV2cmVsLnBvb2xwYXJ0eS5iaXovRGV2UmVsT2ZmZXJpbmdPbnRvbG9neS8zYTcxNjAyOC04YjlhLTQ2ZTQtOTI4Zi0yMDNmNzBjMGZjZmU" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9taWNyb3NvZnQtZGV2cmVsLnBvb2xwYXJ0eS5iaXovRGV2UmVsT2ZmZXJpbmdPbnRvbG9neS8zYTcxNjAyOC04YjlhLTQ2ZTQtOTI4Zi0yMDNmNzBjMGZjZmU class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> </div> </div> </div> </div> <div class="column is-3-desktop is-12-tablet"> <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> asked <local-time format="datetime" datetime="2024-11-23T07:58:05.68+00:00" class="is-visually-hidden">2024-11-23T07:58:05.68+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 71%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=e65713be-e9aa-45b1-ae93-cb0d494b892e" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >Ramana Kopparapu</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">306</span> <span class="is-visually-hidden">Reputation points</span> </span> </div> </div> </div> <div class="margin-top-xxs" hidden > <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> asked <local-time format="datetime" datetime="2024-11-23T07:58:05.68+00:00" class="is-visually-hidden">2024-11-23T07:58:05.68+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 71%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=e65713be-e9aa-45b1-ae93-cb0d494b892e" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >Ramana Kopparapu</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">306</span> <span class="is-visually-hidden">Reputation points</span> </span> </div> </div> </div> </div> </div> </div> </div> <div class="box margin-bottom-xxs"> <div class="columns is-multiline"> <div class="column is-9-desktop is-12-tablet"> <div class="columns is-mobile "> <div class="column is-narrow has-text-right width-150-tablet"> <span class="has-text-subtle font-size-sm" title="" > 0 answers </span> </div> <div class="column"> <h2 class="title is-6 margin-bottom-xxs"> <a href="/en-us/answers/questions/2122382/how-to-fix-timeout-error-in-connection-using-pyodb"> How to fix timeout error in connection using pyodbc in airflow </a> </h2> <p class="has-text-wrap">Hi, I am running an airflow DAG in docker, where I connect to sql server 2019 using a pyodbc connection function. My connection function is as: def get_db_connection(): return pyodbc.connect( 'DRIVER={ODBC Driver 17 for SQL Server};' …</p> <div class="tags margin-top-xxs"> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-sql-server"> <span>SQL Server</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-sql-server" data-bi-name="tag-card-link" href="/en-us/answers/tags/191/sql-server/" > SQL Server </a> <div class="card-content-description" data-test-id="tag-card-description"> A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions. </div> </div> <div class="card-template"> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-sql-server"> 14,067 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-sql-server" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> </div> </div> </div> </div> <div class="column is-3-desktop is-12-tablet"> <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> asked <local-time format="datetime" datetime="2024-11-23T06:00:19.38+00:00" class="is-visually-hidden">2024-11-23T06:00:19.38+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 36%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EXL%3C/text%3E%3C/svg%3E" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=c8536435-b118-479b-89f6-78c596f3bfbb" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >Xavier Langa</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">0</span> <span class="is-visually-hidden">Reputation points</span> </span> </div> </div> </div> <div class="margin-top-xxs" hidden > <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> asked <local-time format="datetime" datetime="2024-11-23T06:00:19.38+00:00" class="is-visually-hidden">2024-11-23T06:00:19.38+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 36%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EXL%3C/text%3E%3C/svg%3E" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=c8536435-b118-479b-89f6-78c596f3bfbb" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >Xavier Langa</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">0</span> <span class="is-visually-hidden">Reputation points</span> </span> </div> </div> </div> </div> </div> </div> </div> <div class="box margin-bottom-xxs"> <div class="columns is-multiline"> <div class="column is-9-desktop is-12-tablet"> <div class="columns is-mobile "> <div class="column is-narrow has-text-right width-150-tablet"> <span class="has-text-subtle font-size-sm" title="" > 0 answers </span> </div> <div class="column"> <h2 class="title is-6 margin-bottom-xxs"> <a href="/en-us/answers/questions/2122361/restore-detected-an-error-on-page-(0-0)-in-databas"> "RESTORE detected an error on page (0:0) in database" error while restoring a database </a> </h2> <p class="has-text-wrap">I have a large database (750GB) that I am backuped on one server and attempted to restore on a different server, I receive the following error - "System.Data.SqlClient.SqlError: RESTORE detected an error on page (0:0) in database…</p> <div class="tags margin-top-xxs"> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-sql-server"> <span>SQL Server</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-sql-server" data-bi-name="tag-card-link" href="/en-us/answers/tags/191/sql-server/" > SQL Server </a> <div class="card-content-description" data-test-id="tag-card-description"> A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions. </div> </div> <div class="card-template"> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-sql-server"> 14,067 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-sql-server" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> </div> </div> </div> </div> <div class="column is-3-desktop is-12-tablet"> <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> asked <local-time format="datetime" datetime="2024-11-23T03:38:48.48+00:00" class="is-visually-hidden">2024-11-23T03:38:48.48+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 38%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=043856c5-01d6-4a11-8593-d3411ede47d1" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >Johnson, Maurice</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">0</span> <span class="is-visually-hidden">Reputation points</span> </span> </div> </div> </div> <div class="margin-top-xxs" hidden > <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> asked <local-time format="datetime" datetime="2024-11-23T03:38:48.48+00:00" class="is-visually-hidden">2024-11-23T03:38:48.48+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 38%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=043856c5-01d6-4a11-8593-d3411ede47d1" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >Johnson, Maurice</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">0</span> <span class="is-visually-hidden">Reputation points</span> </span> </div> </div> </div> </div> </div> </div> </div> <div class="box margin-bottom-xxs"> <div class="columns is-multiline"> <div class="column is-9-desktop is-12-tablet"> <div class="columns is-mobile "> <div class="column is-narrow has-text-right width-150-tablet"> <span class="has-text-subtle font-size-sm" title="" > 0 answers </span> </div> <div class="column"> <h2 class="title is-6 margin-bottom-xxs"> <a href="/en-us/answers/questions/2122122/in-t-sql-debugging-step-into-behaves-like-step-ove"> In T-SQL debugging, "Step Into" behaves like "Step Over." </a> </h2> <p class="has-text-wrap"> visual studio 2022 (17.11.5) Microsoft SQL Server 2022 (RTM) - 16.0.1000.6 (X64) Oct 8 2022 05:58:25 Copyright (C) 2022 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Enterprise 10.0 <X64> (Build 22631: ) (Hypervisor)…</p> <div class="tags margin-top-xxs"> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-sql-server"> <span>SQL Server</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-sql-server" data-bi-name="tag-card-link" href="/en-us/answers/tags/191/sql-server/" > SQL Server </a> <div class="card-content-description" data-test-id="tag-card-description"> A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions. </div> </div> <div class="card-template"> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-sql-server"> 14,067 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-sql-server" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> </div> </div> </div> </div> <div class="column is-3-desktop is-12-tablet"> <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> asked <local-time format="datetime" datetime="2024-11-22T11:14:07.62+00:00" class="is-visually-hidden">2024-11-22T11:14:07.62+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 37%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=c1337595-cb29-48f6-9b50-e3eedb630625" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >Jungsooooo</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">0</span> <span class="is-visually-hidden">Reputation points</span> </span> </div> </div> </div> <div class="margin-top-xxs" > <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> commented <local-time format="datetime" datetime="2024-11-22T22:08:18.9+00:00" class="is-visually-hidden">2024-11-22T22:08:18.9+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=90918973-4b3b-4e75-a7e9-f4afda2f6e06" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >Erland Sommarskog</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">112.8K</span> <span class="is-visually-hidden">Reputation points</span> <span aria-hidden="true">• </span>MVP </span> </div> </div> </div> </div> </div> </div> </div> <div class="box margin-bottom-xxs"> <div class="columns is-multiline"> <div class="column is-9-desktop is-12-tablet"> <div class="columns is-mobile "> <div class="column is-narrow has-text-right width-150-tablet"> <span class="tag border-radius-rounded is-success" title="One of the answers was accepted by the question author." > <span class="icon margin-right-xxs" aria-hidden="true"> <span class="docon docon-check-mark"></span> </span> 1 answer <span class="is-visually-hidden" >One of the answers was accepted by the question author.</span > </span> </div> <div class="column"> <h2 class="title is-6 margin-bottom-xxs"> <a href="/en-us/answers/questions/2121467/migration-azure"> Migration_Azure </a> </h2> <p class="has-text-wrap">I have migrated the data from SQL server to Azure SQL Database. The size on the SQL dataset was around 250 mb but on migration when i checked the size it is around 500 mb. I would like to know the reason and how can i cross check that</p> <div class="tags margin-top-xxs"> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-azure-sql-database"> <span>Azure SQL Database</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-azure-sql-database" data-bi-name="tag-card-link" href="/en-us/answers/tags/51/azure-sql-database/" > Azure SQL Database </a> <div class="card-content-description" data-test-id="tag-card-description"> An Azure relational database service. </div> </div> <div class="card-template"> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-azure-sql-database"> 5,799 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-azure-sql-database" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvMzAyZTI4YjAtMWYwOS00ODExLTlhOWItMmE3MmUwNzcwNTgx" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvMzAyZTI4YjAtMWYwOS00ODExLTlhOWItMmE3MmUwNzcwNTgx class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-sql-server"> <span>SQL Server</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-sql-server" data-bi-name="tag-card-link" href="/en-us/answers/tags/191/sql-server/" > SQL Server </a> <div class="card-content-description" data-test-id="tag-card-description"> A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions. </div> </div> <div class="card-template"> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-sql-server"> 14,067 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-sql-server" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> </div> </div> </div> </div> <div class="column is-3-desktop is-12-tablet"> <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> asked <local-time format="datetime" datetime="2024-11-21T04:04:53.5+00:00" class="is-visually-hidden">2024-11-21T04:04:53.5+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 10%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPH%3C/text%3E%3C/svg%3E" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=d721f0da-adb5-45b5-af14-e2450cf3e329" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >Prateek Hiremath</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">0</span> <span class="is-visually-hidden">Reputation points</span> </span> </div> </div> </div> <div class="margin-top-xxs" > <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> commented <local-time format="datetime" datetime="2024-11-22T22:01:05.5633333+00:00" class="is-visually-hidden">2024-11-22T22:01:05.5633333+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=90918973-4b3b-4e75-a7e9-f4afda2f6e06" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >Erland Sommarskog</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">112.8K</span> <span class="is-visually-hidden">Reputation points</span> <span aria-hidden="true">• </span>MVP </span> </div> </div> </div> </div> </div> </div> </div> <div class="box margin-bottom-xxs"> <div class="columns is-multiline"> <div class="column is-9-desktop is-12-tablet"> <div class="columns is-mobile "> <div class="column is-narrow has-text-right width-150-tablet"> <span class="has-text-subtle font-size-sm" title="" > 0 answers </span> </div> <div class="column"> <h2 class="title is-6 margin-bottom-xxs"> <a href="/en-us/answers/questions/2122321/we-are-setting-up-entra-authentication-for-sql-ser"> We are setting up Entra Authentication for SQL Server. We want to protect against regional outages. How do we configure private DNS so that if a region goes down, SQL Authentication via Entra ID will not be impacted? </a> </h2> <p class="has-text-wrap">We are setting up Entra Authentication for SQL Server on premises via Azure Arc. We want to protect against regional outages. How do we configure private DNS so that if a region goes down, SQL Authentication via Entra ID will not be impacted?</p> <div class="tags margin-top-xxs"> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-azure"> <span>Azure</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-azure" data-bi-name="tag-card-link" href="/en-us/answers/tags/133/azure/" > Azure </a> <div class="card-content-description" data-test-id="tag-card-description"> A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters. </div> </div> <div class="card-template"> <img alt="" class="card-template-icon image is-32x32" src=https://learn.microsoft.com/en-us/media/logos/logo_azure.svg /> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-azure"> 1,019 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-azure" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvOTAzNzA0MjUtYWNhNC00YTM5LTk1MzMtZDUyZTVlMDAyYTVk" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvOTAzNzA0MjUtYWNhNC00YTM5LTk1MzMtZDUyZTVlMDAyYTVk class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-azure-arc"> <span>Azure Arc</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-azure-arc" data-bi-name="tag-card-link" href="/en-us/answers/tags/146/azure-arc/" > Azure Arc </a> <div class="card-content-description" data-test-id="tag-card-description"> A Microsoft cloud service that enables deployment of Azure services across hybrid and multicloud environments. </div> </div> <div class="card-template"> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-azure-arc"> 444 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-azure-arc" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvOWRhMDUzNzItNDcwNi00M2VjLWE4OTktZjQzNmFkYWIzODBk" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvOWRhMDUzNzItNDcwNi00M2VjLWE4OTktZjQzNmFkYWIzODBk class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-sql-server"> <span>SQL Server</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-sql-server" data-bi-name="tag-card-link" href="/en-us/answers/tags/191/sql-server/" > SQL Server </a> <div class="card-content-description" data-test-id="tag-card-description"> A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions. </div> </div> <div class="card-template"> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-sql-server"> 14,067 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-sql-server" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-entra-id"> <span>Microsoft Entra ID</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-entra-id" data-bi-name="tag-card-link" href="/en-us/answers/tags/455/entra-id/" > Microsoft Entra ID </a> <div class="card-content-description" data-test-id="tag-card-description"> A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory. </div> </div> <div class="card-template"> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-entra-id"> 22,289 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-entra-id" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9taWNyb3NvZnQtZGV2cmVsLnBvb2xwYXJ0eS5iaXovRGV2UmVsT2ZmZXJpbmdPbnRvbG9neS8zMTJmMWYwNS1hNDMxLTQxOTMtOGE0ZC1lNjI0NWQ1OTY2ZGU" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9taWNyb3NvZnQtZGV2cmVsLnBvb2xwYXJ0eS5iaXovRGV2UmVsT2ZmZXJpbmdPbnRvbG9neS8zMTJmMWYwNS1hNDMxLTQxOTMtOGE0ZC1lNjI0NWQ1OTY2ZGU class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> </div> </div> </div> </div> <div class="column is-3-desktop is-12-tablet"> <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> asked <local-time format="datetime" datetime="2024-11-22T22:00:30.56+00:00" class="is-visually-hidden">2024-11-22T22:00:30.56+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 19%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=cd6119d6-56a0-4b24-ae21-73cda1eedd9a" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >Seekell, Roger</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">46</span> <span class="is-visually-hidden">Reputation points</span> </span> </div> </div> </div> <div class="margin-top-xxs" hidden > <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> asked <local-time format="datetime" datetime="2024-11-22T22:00:30.56+00:00" class="is-visually-hidden">2024-11-22T22:00:30.56+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 19%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=cd6119d6-56a0-4b24-ae21-73cda1eedd9a" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >Seekell, Roger</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">46</span> <span class="is-visually-hidden">Reputation points</span> </span> </div> </div> </div> </div> </div> </div> </div> <div class="box margin-bottom-xxs"> <div class="columns is-multiline"> <div class="column is-9-desktop is-12-tablet"> <div class="columns is-mobile "> <div class="column is-narrow has-text-right width-150-tablet"> <span class="tag border-radius-rounded has-text-success border-color-success has-background-success-light" title="" > 1 answer </span> </div> <div class="column"> <h2 class="title is-6 margin-bottom-xxs"> <a href="/en-us/answers/questions/2121828/upgrading-from-sql-server-2016-express-sp1-to-sp3"> Upgrading from SQL Server 2016 Express SP1 to SP3 </a> </h2> <p class="has-text-wrap">Which option in SQL Server 2016 Express setup should be chosen to upgrade from SP1 to SP3? This is an in-place upgrade from SQL Server 2016 Express (SP1-GDR).</p> <div class="tags margin-top-xxs"> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-sql-server"> <span>SQL Server</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-sql-server" data-bi-name="tag-card-link" href="/en-us/answers/tags/191/sql-server/" > SQL Server </a> <div class="card-content-description" data-test-id="tag-card-description"> A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions. </div> </div> <div class="card-template"> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-sql-server"> 14,067 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-sql-server" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> </div> </div> </div> </div> <div class="column is-3-desktop is-12-tablet"> <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> asked <local-time format="datetime" datetime="2024-11-21T21:07:43.11+00:00" class="is-visually-hidden">2024-11-21T21:07:43.11+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 85%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPT%3C/text%3E%3C/svg%3E" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=658dbe52-94f3-4886-bde7-751aa2930d61" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >Paul Tormey</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">0</span> <span class="is-visually-hidden">Reputation points</span> </span> </div> </div> </div> <div class="margin-top-xxs" > <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> commented <local-time format="datetime" datetime="2024-11-22T21:48:17.07+00:00" class="is-visually-hidden">2024-11-22T21:48:17.07+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=90918973-4b3b-4e75-a7e9-f4afda2f6e06" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >Erland Sommarskog</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">112.8K</span> <span class="is-visually-hidden">Reputation points</span> <span aria-hidden="true">• </span>MVP </span> </div> </div> </div> </div> </div> </div> </div> <div class="box margin-bottom-xxs"> <div class="columns is-multiline"> <div class="column is-9-desktop is-12-tablet"> <div class="columns is-mobile "> <div class="column is-narrow has-text-right width-150-tablet"> <span class="tag border-radius-rounded has-text-success border-color-success has-background-success-light" title="" > 1 answer </span> </div> <div class="column"> <h2 class="title is-6 margin-bottom-xxs"> <a href="/en-us/answers/questions/2118209/ado-net-connection-failure-to-azure-database-from"> ADO.NET connection failure to Azure Database from VS 2022 SSIS Package running against SQL Server 2022 using Microsoft SQLClient Data Provider </a> </h2> <p class="has-text-wrap">I have a SSIS package running on SQL Server 2022 in VS2022 that connects to a 3rd party Azure database as a source with ADO.NET using Microsoft Entra Password that has been running successfully for a few years. However, recently I needed to make…</p> <div class="tags margin-top-xxs"> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-azure-sql-database"> <span>Azure SQL Database</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-azure-sql-database" data-bi-name="tag-card-link" href="/en-us/answers/tags/51/azure-sql-database/" > Azure SQL Database </a> <div class="card-content-description" data-test-id="tag-card-description"> An Azure relational database service. </div> </div> <div class="card-template"> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-azure-sql-database"> 5,799 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-azure-sql-database" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvMzAyZTI4YjAtMWYwOS00ODExLTlhOWItMmE3MmUwNzcwNTgx" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvMzAyZTI4YjAtMWYwOS00ODExLTlhOWItMmE3MmUwNzcwNTgx class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-sql-server-intergration-services"> <span>SQL Server Integration Services</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-sql-server-intergration-services" data-bi-name="tag-card-link" href="/en-us/answers/tags/253/sql-server-intergration-services/" > SQL Server Integration Services </a> <div class="card-content-description" data-test-id="tag-card-description"> A Microsoft platform for building enterprise-level data integration and data transformations solutions. </div> </div> <div class="card-template"> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-sql-server-intergration-services"> 2,601 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-sql-server-intergration-services" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9taWNyb3NvZnQtZGV2cmVsLnBvb2xwYXJ0eS5iaXovRGV2UmVsT2ZmZXJpbmdPbnRvbG9neS8zYTcxNjAyOC04YjlhLTQ2ZTQtOTI4Zi0yMDNmNzBjMGZjZmU" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9taWNyb3NvZnQtZGV2cmVsLnBvb2xwYXJ0eS5iaXovRGV2UmVsT2ZmZXJpbmdPbnRvbG9neS8zYTcxNjAyOC04YjlhLTQ2ZTQtOTI4Zi0yMDNmNzBjMGZjZmU class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> </div> </div> </div> </div> <div class="column is-3-desktop is-12-tablet"> <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> asked <local-time format="datetime" datetime="2024-11-12T13:59:46.06+00:00" class="is-visually-hidden">2024-11-12T13:59:46.06+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 86%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETT%3C/text%3E%3C/svg%3E" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=b3ab2c86-d251-4ff4-8951-e6b9794c79c8" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >Teresa Thomas</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">1</span> <span class="is-visually-hidden">Reputation point</span> </span> </div> </div> </div> <div class="margin-top-xxs" > <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> commented <local-time format="datetime" datetime="2024-11-22T20:59:21.2+00:00" class="is-visually-hidden">2024-11-22T20:59:21.2+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=79bd6b04-c784-4e48-bfa2-e169fac042f7" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >Mahesh Kurva </a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">975</span> <span class="is-visually-hidden">Reputation points</span> <span aria-hidden="true">• </span>Microsoft Vendor </span> </div> </div> </div> </div> </div> </div> </div> <div class="box margin-bottom-xxs"> <div class="columns is-multiline"> <div class="column is-9-desktop is-12-tablet"> <div class="columns is-mobile "> <div class="column is-narrow has-text-right width-150-tablet"> <span class="tag border-radius-rounded has-text-success border-color-success has-background-success-light" title="" > 1 answer </span> </div> <div class="column"> <h2 class="title is-6 margin-bottom-xxs"> <a href="/en-us/answers/questions/2121865/migrating-existing-packages-c-task-is-failing-on-a"> Migrating existing packages - C# task is failing on a new server </a> </h2> <p class="has-text-wrap">Hi, We're migrating our SSIS server to a new server. Original server is Windows Server 16, SQL Server 2019. New server is Windows Server 2022 and OS is SQL Server 2022. We're getting the error on the packages that use C# script task: Code: 0x00000005 …</p> <div class="tags margin-top-xxs"> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-sql-server"> <span>SQL Server</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-sql-server" data-bi-name="tag-card-link" href="/en-us/answers/tags/191/sql-server/" > SQL Server </a> <div class="card-content-description" data-test-id="tag-card-description"> A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions. </div> </div> <div class="card-template"> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-sql-server"> 14,067 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-sql-server" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-tsql"> <span>Transact-SQL</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-tsql" data-bi-name="tag-card-link" href="/en-us/answers/tags/457/tsql/" > Transact-SQL </a> <div class="card-content-description" data-test-id="tag-card-description"> A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions. </div> </div> <div class="card-template"> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-tsql"> 4,663 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-tsql" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvYmJhNTNmOWYtYTZlMS00Zjc0LWFhMTctNTMxMWVmMWM0NzI3" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvYmJhNTNmOWYtYTZlMS00Zjc0LWFhMTctNTMxMWVmMWM0NzI3 class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> </div> </div> </div> </div> <div class="column is-3-desktop is-12-tablet"> <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> asked <local-time format="datetime" datetime="2024-11-21T23:58:54.0533333+00:00" class="is-visually-hidden">2024-11-21T23:58:54.0533333+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 31%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=433db142-44f8-4a48-93f7-29a0819ca9ca" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >Naomi Nosonovsky</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">7,911</span> <span class="is-visually-hidden">Reputation points</span> </span> </div> </div> </div> <div class="margin-top-xxs" > <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> edited an answer <local-time format="datetime" datetime="2024-11-22T20:57:22.1866667+00:00" class="is-visually-hidden">2024-11-22T20:57:22.1866667+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=3e0eb261-997e-4688-98cd-85d9b273bb7e" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >Yitzhak Khabinsky</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">26,041</span> <span class="is-visually-hidden">Reputation points</span> </span> </div> </div> </div> </div> </div> </div> </div> <div class="box margin-bottom-xxs"> <div class="columns is-multiline"> <div class="column is-9-desktop is-12-tablet"> <div class="columns is-mobile "> <div class="column is-narrow has-text-right width-150-tablet"> <span class="tag border-radius-rounded has-text-success border-color-success has-background-success-light" title="" > 2 answers </span> </div> <div class="column"> <h2 class="title is-6 margin-bottom-xxs"> <a href="/en-us/answers/questions/1108094/error-occurred-during-local-report-processing"> Error occurred during local report processing </a> </h2> <p class="has-text-wrap">Hi Experts, i am getting error while generating the report: I have used parameters like : and getting error as below screenshot The 'Value' expression for the query parameter '?' contains an error: Overload resolution failed because…</p> <div class="tags margin-top-xxs"> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-sql-server-reporting-services"> <span>SQL Server Reporting Services</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-sql-server-reporting-services" data-bi-name="tag-card-link" href="/en-us/answers/tags/218/sql-server-reporting-services/" > SQL Server Reporting Services </a> <div class="card-content-description" data-test-id="tag-card-description"> A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports. </div> </div> <div class="card-template"> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-sql-server-reporting-services"> 2,944 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-sql-server-reporting-services" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvZWRhN2Q0YTUtMTFlMi00ZDZmLWIzNzktMGQ0OTZmMmExN2E1" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvZWRhN2Q0YTUtMTFlMi00ZDZmLWIzNzktMGQ0OTZmMmExN2E1 class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> </div> </div> </div> </div> <div class="column is-3-desktop is-12-tablet"> <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> asked <local-time format="datetime" datetime="2022-11-29T06:28:37.413+00:00" class="is-visually-hidden">2022-11-29T06:28:37.413+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 21%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERV%3C/text%3E%3C/svg%3E" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=9d5bdd2e-16d8-4bbe-ad3d-f26b3c6fbd89" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >Rathore, Vaibhav Singh</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">1</span> <span class="is-visually-hidden">Reputation point</span> </span> </div> </div> </div> <div class="margin-top-xxs" > <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> commented <local-time format="datetime" datetime="2024-11-22T19:06:13.44+00:00" class="is-visually-hidden">2024-11-22T19:06:13.44+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(243.2, 11%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=761a105e-e853-4840-a6d7-be6a0e488931" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >BremerhavenRocks</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">0</span> <span class="is-visually-hidden">Reputation points</span> </span> </div> </div> </div> </div> </div> </div> </div> <div class="box margin-bottom-xxs"> <div class="columns is-multiline"> <div class="column is-9-desktop is-12-tablet"> <div class="columns is-mobile "> <div class="column is-narrow has-text-right width-150-tablet"> <span class="tag border-radius-rounded has-text-success border-color-success has-background-success-light" title="" > 1 answer </span> </div> <div class="column"> <h2 class="title is-6 margin-bottom-xxs"> <a href="/en-us/answers/questions/2121322/how-to-create-db-for-reservation"> How to create DB for Reservation </a> </h2> <p class="has-text-wrap">I have a reservation - SQL Database Single/Elastic Pool General Purpose - Compute Gen5 Could you please share with me instructions on how to create DB suitable for my reservation As I understand if I create DB correctly it will link to the…</p> <div class="tags margin-top-xxs"> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-azure-sql-database"> <span>Azure SQL Database</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-azure-sql-database" data-bi-name="tag-card-link" href="/en-us/answers/tags/51/azure-sql-database/" > Azure SQL Database </a> <div class="card-content-description" data-test-id="tag-card-description"> An Azure relational database service. </div> </div> <div class="card-template"> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-azure-sql-database"> 5,799 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-azure-sql-database" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvMzAyZTI4YjAtMWYwOS00ODExLTlhOWItMmE3MmUwNzcwNTgx" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvMzAyZTI4YjAtMWYwOS00ODExLTlhOWItMmE3MmUwNzcwNTgx class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-sql-server"> <span>SQL Server</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-sql-server" data-bi-name="tag-card-link" href="/en-us/answers/tags/191/sql-server/" > SQL Server </a> <div class="card-content-description" data-test-id="tag-card-description"> A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions. </div> </div> <div class="card-template"> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-sql-server"> 14,067 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-sql-server" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> </div> </div> </div> </div> <div class="column is-3-desktop is-12-tablet"> <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> asked <local-time format="datetime" datetime="2024-11-20T18:06:39.1+00:00" class="is-visually-hidden">2024-11-20T18:06:39.1+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 79%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EED%3C/text%3E%3C/svg%3E" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=bdc0a8c7-a937-49ee-913e-71bb4f29ecd4" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >Easy Drive</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">0</span> <span class="is-visually-hidden">Reputation points</span> </span> </div> </div> </div> <div class="margin-top-xxs" > <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> commented <local-time format="datetime" datetime="2024-11-22T16:08:26.4433333+00:00" class="is-visually-hidden">2024-11-22T16:08:26.4433333+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=7146b9b9-c0fd-4759-98ce-049fdcbedde7" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >NIKHILA NETHIKUNTA</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">3,505</span> <span class="is-visually-hidden">Reputation points</span> <span aria-hidden="true">• </span>Microsoft Vendor </span> </div> </div> </div> </div> </div> </div> </div> <div class="box margin-bottom-xxs"> <div class="columns is-multiline"> <div class="column is-9-desktop is-12-tablet"> <div class="columns is-mobile "> <div class="column is-narrow has-text-right width-150-tablet"> <span class="tag border-radius-rounded is-success" title="One of the answers was accepted by the question author." > <span class="icon margin-right-xxs" aria-hidden="true"> <span class="docon docon-check-mark"></span> </span> 1 answer <span class="is-visually-hidden" >One of the answers was accepted by the question author.</span > </span> </div> <div class="column"> <h2 class="title is-6 margin-bottom-xxs"> <a href="/en-us/answers/questions/1083390/sql-server-2019-installation-failed-with-206805231"> SQL Server 2019 installation failed with 2068052310 Exit code </a> </h2> <p class="has-text-wrap">SQL Server 2019 installation failed with below error. I have tried manually installing the msodbcsql.msi and re-tried the SQL server installation, but that also failed. The SQL2019-SSEI-Expr.exe was downloaded from microsoft.com </p> <div class="tags margin-top-xxs"> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-sql-server"> <span>SQL Server</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-sql-server" data-bi-name="tag-card-link" href="/en-us/answers/tags/191/sql-server/" > SQL Server </a> <div class="card-content-description" data-test-id="tag-card-description"> A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions. </div> </div> <div class="card-template"> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-sql-server"> 14,067 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-sql-server" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> </div> </div> </div> </div> <div class="column is-3-desktop is-12-tablet"> <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> asked <local-time format="datetime" datetime="2022-11-10T08:37:44.4+00:00" class="is-visually-hidden">2022-11-10T08:37:44.4+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(118.4, 31%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKJ%3C/text%3E%3C/svg%3E" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=37b3c1f1-3bad-452a-a9f1-d36464df81a4" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >Kizhakkethiruoth, Jagadeesh</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">56</span> <span class="is-visually-hidden">Reputation points</span> </span> </div> </div> </div> <div class="margin-top-xxs" > <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> commented <local-time format="datetime" datetime="2024-11-22T16:07:38.6933333+00:00" class="is-visually-hidden">2024-11-22T16:07:38.6933333+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(176, 42%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKL%3C/text%3E%3C/svg%3E" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=ba5542ae-bfe8-4fb7-a100-c06552efe5fd" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >Kacper Lugiewicz</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">0</span> <span class="is-visually-hidden">Reputation points</span> </span> </div> </div> </div> </div> </div> </div> </div> <div class="box margin-bottom-xxs"> <div class="columns is-multiline"> <div class="column is-9-desktop is-12-tablet"> <div class="columns is-mobile "> <div class="column is-narrow has-text-right width-150-tablet"> <span class="tag border-radius-rounded has-text-success border-color-success has-background-success-light" title="" > 2 answers </span> </div> <div class="column"> <h2 class="title is-6 margin-bottom-xxs"> <a href="/en-us/answers/questions/2119458/possibity-of-upgrade-and-migration-from-sql-2014-t"> Possibity of upgrade and migration from SQL 2014 to SQL 2022 </a> </h2> <p class="has-text-wrap">HI Team, I am having one system ( Procesor: Intel Xeon E-2224 3.4GHz, 8M c ache, 4C/4T, turbo (71W)) with installed 2014 SQL I would like to upgrade to 2022 Standard SQL is it possible and what is most easy way. Kind regards,</p> <div class="tags margin-top-xxs"> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-sql-server"> <span>SQL Server</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-sql-server" data-bi-name="tag-card-link" href="/en-us/answers/tags/191/sql-server/" > SQL Server </a> <div class="card-content-description" data-test-id="tag-card-description"> A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions. </div> </div> <div class="card-template"> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-sql-server"> 14,067 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-sql-server" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-sql-server-migration-assistant"> <span>SQL Server Migration Assistant</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-sql-server-migration-assistant" data-bi-name="tag-card-link" href="/en-us/answers/tags/292/sql-server-migration-assistant/" > SQL Server Migration Assistant </a> <div class="card-content-description" data-test-id="tag-card-description"> A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE. </div> </div> <div class="card-template"> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-sql-server-migration-assistant"> 540 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-sql-server-migration-assistant" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9taWNyb3NvZnQtZGV2cmVsLnBvb2xwYXJ0eS5iaXovRGV2UmVsT2ZmZXJpbmdPbnRvbG9neS9kM2FlMmY2MC1jYmIxLTQ2MmMtODllMi01ZTQwNDQyNzFkNjE" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9taWNyb3NvZnQtZGV2cmVsLnBvb2xwYXJ0eS5iaXovRGV2UmVsT2ZmZXJpbmdPbnRvbG9neS9kM2FlMmY2MC1jYmIxLTQ2MmMtODllMi01ZTQwNDQyNzFkNjE class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-sql-server"> <span>SQL Server</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-sql-server" data-bi-name="tag-card-link" href="/en-us/answers/tags/191/sql-server/" > SQL Server </a> <div class="card-content-description" data-test-id="tag-card-description"> A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions. </div> </div> <div class="card-template"> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-sql-server"> 14,067 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-sql-server" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-sql-server-migration-assistant"> <span>SQL Server Migration Assistant</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-sql-server-migration-assistant" data-bi-name="tag-card-link" href="/en-us/answers/tags/292/sql-server-migration-assistant/" > SQL Server Migration Assistant </a> <div class="card-content-description" data-test-id="tag-card-description"> A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE. </div> </div> <div class="card-template"> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-sql-server-migration-assistant"> 540 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-sql-server-migration-assistant" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9taWNyb3NvZnQtZGV2cmVsLnBvb2xwYXJ0eS5iaXovRGV2UmVsT2ZmZXJpbmdPbnRvbG9neS9kM2FlMmY2MC1jYmIxLTQ2MmMtODllMi01ZTQwNDQyNzFkNjE" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9taWNyb3NvZnQtZGV2cmVsLnBvb2xwYXJ0eS5iaXovRGV2UmVsT2ZmZXJpbmdPbnRvbG9neS9kM2FlMmY2MC1jYmIxLTQ2MmMtODllMi01ZTQwNDQyNzFkNjE class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> </div> </div> </div> </div> <div class="column is-3-desktop is-12-tablet"> <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> asked <local-time format="datetime" datetime="2024-11-15T08:49:17.6066667+00:00" class="is-visually-hidden">2024-11-15T08:49:17.6066667+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 18%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=8bc1fa1a-80bc-4765-a605-d580afc94b00" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >Tarik sendro</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">0</span> <span class="is-visually-hidden">Reputation points</span> </span> </div> </div> </div> <div class="margin-top-xxs" > <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> commented <local-time format="datetime" datetime="2024-11-22T14:37:11.7166667+00:00" class="is-visually-hidden">2024-11-22T14:37:11.7166667+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 18%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=8bc1fa1a-80bc-4765-a605-d580afc94b00" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >Tarik sendro</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">0</span> <span class="is-visually-hidden">Reputation points</span> </span> </div> </div> </div> </div> </div> </div> </div> <div class="box margin-bottom-xxs"> <div class="columns is-multiline"> <div class="column is-9-desktop is-12-tablet"> <div class="columns is-mobile "> <div class="column is-narrow has-text-right width-150-tablet"> <span class="tag border-radius-rounded has-text-success border-color-success has-background-success-light" title="" > 2 answers </span> </div> <div class="column"> <h2 class="title is-6 margin-bottom-xxs"> <a href="/en-us/answers/questions/2119458/possibity-of-upgrade-and-migration-from-sql-2014-t"> Possibity of upgrade and migration from SQL 2014 to SQL 2022 </a> </h2> <p class="has-text-wrap">HI Team, I am having one system ( Procesor: Intel Xeon E-2224 3.4GHz, 8M c ache, 4C/4T, turbo (71W)) with installed 2014 SQL I would like to upgrade to 2022 Standard SQL is it possible and what is most easy way. Kind regards,</p> <div class="tags margin-top-xxs"> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-sql-server"> <span>SQL Server</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-sql-server" data-bi-name="tag-card-link" href="/en-us/answers/tags/191/sql-server/" > SQL Server </a> <div class="card-content-description" data-test-id="tag-card-description"> A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions. </div> </div> <div class="card-template"> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-sql-server"> 14,067 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-sql-server" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-sql-server-migration-assistant"> <span>SQL Server Migration Assistant</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-sql-server-migration-assistant" data-bi-name="tag-card-link" href="/en-us/answers/tags/292/sql-server-migration-assistant/" > SQL Server Migration Assistant </a> <div class="card-content-description" data-test-id="tag-card-description"> A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE. </div> </div> <div class="card-template"> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-sql-server-migration-assistant"> 540 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-sql-server-migration-assistant" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9taWNyb3NvZnQtZGV2cmVsLnBvb2xwYXJ0eS5iaXovRGV2UmVsT2ZmZXJpbmdPbnRvbG9neS9kM2FlMmY2MC1jYmIxLTQ2MmMtODllMi01ZTQwNDQyNzFkNjE" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9taWNyb3NvZnQtZGV2cmVsLnBvb2xwYXJ0eS5iaXovRGV2UmVsT2ZmZXJpbmdPbnRvbG9neS9kM2FlMmY2MC1jYmIxLTQ2MmMtODllMi01ZTQwNDQyNzFkNjE class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-sql-server"> <span>SQL Server</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-sql-server" data-bi-name="tag-card-link" href="/en-us/answers/tags/191/sql-server/" > SQL Server </a> <div class="card-content-description" data-test-id="tag-card-description"> A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions. </div> </div> <div class="card-template"> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-sql-server"> 14,067 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-sql-server" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-sql-server-migration-assistant"> <span>SQL Server Migration Assistant</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-sql-server-migration-assistant" data-bi-name="tag-card-link" href="/en-us/answers/tags/292/sql-server-migration-assistant/" > SQL Server Migration Assistant </a> <div class="card-content-description" data-test-id="tag-card-description"> A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE. </div> </div> <div class="card-template"> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-sql-server-migration-assistant"> 540 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-sql-server-migration-assistant" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9taWNyb3NvZnQtZGV2cmVsLnBvb2xwYXJ0eS5iaXovRGV2UmVsT2ZmZXJpbmdPbnRvbG9neS9kM2FlMmY2MC1jYmIxLTQ2MmMtODllMi01ZTQwNDQyNzFkNjE" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9taWNyb3NvZnQtZGV2cmVsLnBvb2xwYXJ0eS5iaXovRGV2UmVsT2ZmZXJpbmdPbnRvbG9neS9kM2FlMmY2MC1jYmIxLTQ2MmMtODllMi01ZTQwNDQyNzFkNjE class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> </div> </div> </div> </div> <div class="column is-3-desktop is-12-tablet"> <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> asked <local-time format="datetime" datetime="2024-11-15T08:49:17.6066667+00:00" class="is-visually-hidden">2024-11-15T08:49:17.6066667+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 18%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=8bc1fa1a-80bc-4765-a605-d580afc94b00" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >Tarik sendro</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">0</span> <span class="is-visually-hidden">Reputation points</span> </span> </div> </div> </div> <div class="margin-top-xxs" > <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> commented <local-time format="datetime" datetime="2024-11-22T14:37:11.7166667+00:00" class="is-visually-hidden">2024-11-22T14:37:11.7166667+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 18%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=8bc1fa1a-80bc-4765-a605-d580afc94b00" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >Tarik sendro</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">0</span> <span class="is-visually-hidden">Reputation points</span> </span> </div> </div> </div> </div> </div> </div> </div> <div class="box margin-bottom-xxs"> <div class="columns is-multiline"> <div class="column is-9-desktop is-12-tablet"> <div class="columns is-mobile "> <div class="column is-narrow has-text-right width-150-tablet"> <span class="tag border-radius-rounded has-text-success border-color-success has-background-success-light" title="" > 1 answer </span> </div> <div class="column"> <h2 class="title is-6 margin-bottom-xxs"> <a href="/en-us/answers/questions/2117392/(completed-with-warning)-the-site-database-has-a-b"> [Completed with warning]:The site database has a backlog of SQL change tracking data. For more information </a> </h2> <p class="has-text-wrap">We got this issue when we run prerequisites check in Configuration Manager (SCCM). [Completed with warning]:The site database has a backlog of SQL change tracking data. For more information see https://go.microsoft.com/fwlink/?linkid=2027576</p> <div class="tags margin-top-xxs"> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-sql-server"> <span>SQL Server</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-sql-server" data-bi-name="tag-card-link" href="/en-us/answers/tags/191/sql-server/" > SQL Server </a> <div class="card-content-description" data-test-id="tag-card-description"> A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions. </div> </div> <div class="card-template"> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-sql-server"> 14,067 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-sql-server" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-windows-server"> <span>Windows Server</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-windows-server" data-bi-name="tag-card-link" href="/en-us/answers/tags/220/windows-server/" > Windows Server </a> <div class="card-content-description" data-test-id="tag-card-description"> A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications. </div> </div> <div class="card-template"> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-windows-server"> 13,303 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-windows-server" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvZjEyY2YwODctNTgyZC00OGFjLWEwODUtMGMxOWFkZjFlMzkx" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvZjEyY2YwODctNTgyZC00OGFjLWEwODUtMGMxOWFkZjFlMzkx class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-configuration-manager"> <span>Microsoft Configuration Manager</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-configuration-manager" data-bi-name="tag-card-link" href="/en-us/answers/tags/417/configuration-manager/" > Microsoft Configuration Manager </a> <div class="card-content-description" data-test-id="tag-card-description"> An integrated solution for for managing large groups of personal computers and servers. </div> </div> <div class="card-template"> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-configuration-manager"> 4,482 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-configuration-manager" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9taWNyb3NvZnQtZGV2cmVsLnBvb2xwYXJ0eS5iaXovRGV2UmVsT2ZmZXJpbmdPbnRvbG9neS82YThjODNiZS1mMWRlLTRlOTAtYmRlMC1iZDA5Nzk5OWE2MGM" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9taWNyb3NvZnQtZGV2cmVsLnBvb2xwYXJ0eS5iaXovRGV2UmVsT2ZmZXJpbmdPbnRvbG9neS82YThjODNiZS1mMWRlLTRlOTAtYmRlMC1iZDA5Nzk5OWE2MGM class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> </div> </div> </div> </div> <div class="column is-3-desktop is-12-tablet"> <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> asked <local-time format="datetime" datetime="2024-11-10T09:06:45.25+00:00" class="is-visually-hidden">2024-11-10T09:06:45.25+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 50%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=d45a5e0e-c63b-4e9e-ac1b-426daa98d97c" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >Mirza Anwarulla Baig</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">0</span> <span class="is-visually-hidden">Reputation points</span> </span> </div> </div> </div> <div class="margin-top-xxs" > <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> commented <local-time format="datetime" datetime="2024-11-22T13:16:02.9733333+00:00" class="is-visually-hidden">2024-11-22T13:16:02.9733333+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="https://techprofile.blob.core.windows.net/images/L2Smn6t8v0KySntkzQHXxA.png?8D854E" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=9fa6642f-7cab-42bf-b24a-7b64cd01d7c4" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >Sherry Kissinger</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">5,171</span> <span class="is-visually-hidden">Reputation points</span> </span> </div> </div> </div> </div> </div> </div> </div> <div class="box margin-bottom-xxs"> <div class="columns is-multiline"> <div class="column is-9-desktop is-12-tablet"> <div class="columns is-mobile "> <div class="column is-narrow has-text-right width-150-tablet"> <span class="tag border-radius-rounded is-success" title="One of the answers was accepted by the question author." > <span class="icon margin-right-xxs" aria-hidden="true"> <span class="docon docon-check-mark"></span> </span> 1 answer <span class="is-visually-hidden" >One of the answers was accepted by the question author.</span > </span> </div> <div class="column"> <h2 class="title is-6 margin-bottom-xxs"> <a href="/en-us/answers/questions/2115767/(microsoft)(odbc-driver-18-for-sql-server)ssl-prov"> [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider. The certificate chain was issued by an authority that is not trusted. [Microsoft][ODBC Driver 18 for SQL Server]Client unable to establish connection. </a> </h2> <p class="has-text-wrap">Hello, researched and around still having issues on connecting into SQL Server. Error getting is: [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider. The certificate chain was issued by an authority that is not trusted. [Microsoft][ODBC Driver 18 for…</p> <div class="tags margin-top-xxs"> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-sql-server"> <span>SQL Server</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-sql-server" data-bi-name="tag-card-link" href="/en-us/answers/tags/191/sql-server/" > SQL Server </a> <div class="card-content-description" data-test-id="tag-card-description"> A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions. </div> </div> <div class="card-template"> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-sql-server"> 14,067 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-sql-server" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> </div> </div> </div> </div> <div class="column is-3-desktop is-12-tablet"> <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> asked <local-time format="datetime" datetime="2024-11-05T17:45:22.7233333+00:00" class="is-visually-hidden">2024-11-05T17:45:22.7233333+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 45%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=c3f24d5f-ee40-4f97-b236-ea903a9529a5" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >techresearch7777777</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">1,901</span> <span class="is-visually-hidden">Reputation points</span> </span> </div> </div> </div> <div class="margin-top-xxs" > <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> accepted <local-time format="datetime" datetime="2024-11-22T10:40:55.3466667+00:00" class="is-visually-hidden">2024-11-22T10:40:55.3466667+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 45%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=c3f24d5f-ee40-4f97-b236-ea903a9529a5" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >techresearch7777777</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">1,901</span> <span class="is-visually-hidden">Reputation points</span> </span> </div> </div> </div> </div> </div> </div> </div> <div class="box margin-bottom-xxs"> <div class="columns is-multiline"> <div class="column is-9-desktop is-12-tablet"> <div class="columns is-mobile "> <div class="column is-narrow has-text-right width-150-tablet"> <span class="tag border-radius-rounded has-text-success border-color-success has-background-success-light" title="" > 2 answers </span> </div> <div class="column"> <h2 class="title is-6 margin-bottom-xxs"> <a href="/en-us/answers/questions/1097850/critical-error-for-sharepoint-config-database"> Critical Error for SharePoint_Config Database </a> </h2> <p class="has-text-wrap">Hi, I searched all forums for three days but can't find the answer. These topics won't work : Answer 1 Answer 2 Answer 3 The server returns this critical error: SQL database login for 'SharePoint_Config' on instance 'ServerSql' failed.…</p> <div class="tags margin-top-xxs"> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-sql-server-reporting-services"> <span>SQL Server Reporting Services</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-sql-server-reporting-services" data-bi-name="tag-card-link" href="/en-us/answers/tags/218/sql-server-reporting-services/" > SQL Server Reporting Services </a> <div class="card-content-description" data-test-id="tag-card-description"> A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports. </div> </div> <div class="card-template"> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-sql-server-reporting-services"> 2,944 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-sql-server-reporting-services" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvZWRhN2Q0YTUtMTFlMi00ZDZmLWIzNzktMGQ0OTZmMmExN2E1" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvZWRhN2Q0YTUtMTFlMi00ZDZmLWIzNzktMGQ0OTZmMmExN2E1 class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-office-sp-development"> <span>SharePoint Development</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-office-sp-development" data-bi-name="tag-card-link" href="/en-us/answers/tags/336/office-sp-development/" > SharePoint Development </a> <div class="card-content-description" data-test-id="tag-card-description"> <span class="line-clamp-4 font-size-sm" ><span class="line-clamp-2"><strong>SharePoint:</strong> A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.</span ><span class="line-clamp-2"><strong>Development:</strong> The process of researching, productizing, and refining new or existing technologies.</span></span > </div> </div> <div class="card-template"> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-office-sp-development"> 3,071 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-office-sp-development" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9taWNyb3NvZnQtZGV2cmVsLnBvb2xwYXJ0eS5iaXovRGV2UmVsTWFjaGluZUdlbmVyYXRlZENvbXBvdW5kVGF4b25vbXkvNzVlOGE1ZTQtZjM0Zi00YTMzLWI1OGMtZmJjMjNmOTQyMmM1" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9taWNyb3NvZnQtZGV2cmVsLnBvb2xwYXJ0eS5iaXovRGV2UmVsTWFjaGluZUdlbmVyYXRlZENvbXBvdW5kVGF4b25vbXkvNzVlOGE1ZTQtZjM0Zi00YTMzLWI1OGMtZmJjMjNmOTQyMmM1 class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> </div> </div> </div> </div> <div class="column is-3-desktop is-12-tablet"> <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> asked <local-time format="datetime" datetime="2022-11-21T10:40:33.883+00:00" class="is-visually-hidden">2022-11-21T10:40:33.883+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 89%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=6d88a93c-86c9-4be5-9ef3-cec192b50f50" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >Safa</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">1</span> <span class="is-visually-hidden">Reputation point</span> </span> </div> </div> </div> <div class="margin-top-xxs" > <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> commented <local-time format="datetime" datetime="2024-11-22T09:36:12.8+00:00" class="is-visually-hidden">2024-11-22T09:36:12.8+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 10%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=93fb1f0b-4fd4-4a4f-b9aa-9b12e8645866" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >Sudhir Singare</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">0</span> <span class="is-visually-hidden">Reputation points</span> </span> </div> </div> </div> </div> </div> </div> </div> <div class="box margin-bottom-xxs"> <div class="columns is-multiline"> <div class="column is-9-desktop is-12-tablet"> <div class="columns is-mobile "> <div class="column is-narrow has-text-right width-150-tablet"> <span class="tag border-radius-rounded has-text-success border-color-success has-background-success-light" title="" > 2 answers </span> </div> <div class="column"> <h2 class="title is-6 margin-bottom-xxs"> <a href="/en-us/answers/questions/2120360/sql-recursive-query-to-generate-output"> SQL Recursive query to generate output </a> </h2> <p class="has-text-wrap">Hello Expert , I am trying to generate one output as: Two different Tables: Table1: Cat1, Vol,Rank Cat1, 1, 1 Cat1, 4, 2 Cat1, 6, 3 Table2: Rank, Vol_Threshold, Partition 1, 21, 1 2, 27, 2 3, 34, 3 Would like to generate output: if running first…</p> <div class="tags margin-top-xxs"> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-sql-server"> <span>SQL Server</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-sql-server" data-bi-name="tag-card-link" href="/en-us/answers/tags/191/sql-server/" > SQL Server </a> <div class="card-content-description" data-test-id="tag-card-description"> A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions. </div> </div> <div class="card-template"> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-sql-server"> 14,067 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-sql-server" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-tsql"> <span>Transact-SQL</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-tsql" data-bi-name="tag-card-link" href="/en-us/answers/tags/457/tsql/" > Transact-SQL </a> <div class="card-content-description" data-test-id="tag-card-description"> A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions. </div> </div> <div class="card-template"> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-tsql"> 4,663 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-tsql" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvYmJhNTNmOWYtYTZlMS00Zjc0LWFhMTctNTMxMWVmMWM0NzI3" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvYmJhNTNmOWYtYTZlMS00Zjc0LWFhMTctNTMxMWVmMWM0NzI3 class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> </div> </div> </div> </div> <div class="column is-3-desktop is-12-tablet"> <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> asked <local-time format="datetime" datetime="2024-11-18T12:14:09.0766667+00:00" class="is-visually-hidden">2024-11-18T12:14:09.0766667+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(131.20000000000002, 89%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAT%3C/text%3E%3C/svg%3E" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=41a8eecd-9a47-42fc-b8e1-738eb49de710" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >Avanish Tomar</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">0</span> <span class="is-visually-hidden">Reputation points</span> </span> </div> </div> </div> <div class="margin-top-xxs" > <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> commented <local-time format="datetime" datetime="2024-11-22T07:17:52.2866667+00:00" class="is-visually-hidden">2024-11-22T07:17:52.2866667+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="https://techprofile.blob.core.windows.net/images/YC3KiAudCk6A0I6NB9vOyA.png?8DA953" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=88ca2d60-9d0b-4e0a-80d0-8e8d07dbcec8" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >LiHongMSFT-4306</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">28,806</span> <span class="is-visually-hidden">Reputation points</span> </span> </div> </div> </div> </div> </div> </div> </div> <div class="box margin-bottom-xxs"> <div class="columns is-multiline"> <div class="column is-9-desktop is-12-tablet"> <div class="columns is-mobile "> <div class="column is-narrow has-text-right width-150-tablet"> <span class="tag border-radius-rounded has-text-success border-color-success has-background-success-light" title="" > 2 answers </span> </div> <div class="column"> <h2 class="title is-6 margin-bottom-xxs"> <a href="/en-us/answers/questions/2117900/transpose-rows-into-columns-based-on-id"> Transpose rows into columns based on ID. </a> </h2> <p class="has-text-wrap">I have a table with two columns, ProductionEventId and Value. The ProductionEventId column contains unique ids that repeat for each value in the Value column. See below. How can I have one occurrence of the ProductionEventId with the multiple values in…</p> <div class="tags margin-top-xxs"> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-sql-server"> <span>SQL Server</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-sql-server" data-bi-name="tag-card-link" href="/en-us/answers/tags/191/sql-server/" > SQL Server </a> <div class="card-content-description" data-test-id="tag-card-description"> A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions. </div> </div> <div class="card-template"> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-sql-server"> 14,067 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-sql-server" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> </div> </div> </div> </div> <div class="column is-3-desktop is-12-tablet"> <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> asked <local-time format="datetime" datetime="2024-11-11T20:25:35.5633333+00:00" class="is-visually-hidden">2024-11-11T20:25:35.5633333+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 27%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMD%3C/text%3E%3C/svg%3E" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=b672ee73-7eac-4124-9cba-ddca4040d1a8" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >Michael Deaton</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">0</span> <span class="is-visually-hidden">Reputation points</span> </span> </div> </div> </div> <div class="margin-top-xxs" > <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> commented <local-time format="datetime" datetime="2024-11-22T07:15:04.3066667+00:00" class="is-visually-hidden">2024-11-22T07:15:04.3066667+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="https://techprofile.blob.core.windows.net/images/YC3KiAudCk6A0I6NB9vOyA.png?8DA953" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=88ca2d60-9d0b-4e0a-80d0-8e8d07dbcec8" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >LiHongMSFT-4306</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">28,806</span> <span class="is-visually-hidden">Reputation points</span> </span> </div> </div> </div> </div> </div> </div> </div> <div class="box margin-bottom-xxs"> <div class="columns is-multiline"> <div class="column is-9-desktop is-12-tablet"> <div class="columns is-mobile "> <div class="column is-narrow has-text-right width-150-tablet"> <span class="tag border-radius-rounded has-text-success border-color-success has-background-success-light" title="" > 2 answers </span> </div> <div class="column"> <h2 class="title is-6 margin-bottom-xxs"> <a href="/en-us/answers/questions/2121702/how-to-fix-setup-sql-express-server-2022"> How to fix setup SQL Express Server 2022 </a> </h2> <p class="has-text-wrap">Can't install SQL Server (Express) 2022 Detail.txt When i first tried to install SQL Server, the error '%1 is not a win32 app'. I tried installign again without firewall after removing everything. Now I have this issue.</p> <div class="tags margin-top-xxs"> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-sql-server"> <span>SQL Server</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-sql-server" data-bi-name="tag-card-link" href="/en-us/answers/tags/191/sql-server/" > SQL Server </a> <div class="card-content-description" data-test-id="tag-card-description"> A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions. </div> </div> <div class="card-template"> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-sql-server"> 14,067 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-sql-server" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> </div> </div> </div> </div> <div class="column is-3-desktop is-12-tablet"> <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> asked <local-time format="datetime" datetime="2024-11-21T13:18:00.3466667+00:00" class="is-visually-hidden">2024-11-21T13:18:00.3466667+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 97%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVB%3C/text%3E%3C/svg%3E" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=33b97940-b5b5-49e5-ba09-3d17ea60569c" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >Verstraete Brent</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">0</span> <span class="is-visually-hidden">Reputation points</span> </span> </div> </div> </div> <div class="margin-top-xxs" > <div class="margin-bottom-xs"> <span class="display-block font-size-xs has-line-height-reset"> answered <local-time format="datetime" datetime="2024-11-22T06:51:36.7766667+00:00" class="is-visually-hidden">2024-11-22T06:51:36.7766667+00:00</local-time> </span> <div class="display-flex align-items-center margin-top-xxs"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="https://techprofile.blob.core.windows.net/images/LaMnhm6dYUm819lrFKr8rA.png?8D834F" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=8627a32d-9d6e-4961-bcd7-d96b14aafcac" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >ZoeHui-MSFT</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">38,066</span> <span class="is-visually-hidden">Reputation points</span> </span> </div> </div> </div> </div> </div> </div> </div> <nav class="pagination is-centered margin-top-lg margin-bottom-xs" aria-label="pagination" data-test-id="pagination-list" > <ul class="pagination-list"> <li> <a type="button" data-test-id="pagination-button-back" class="pagination-link display-none" aria-label="Previous" href="/en-us/answers/tags/191/sql-server?page=0" aria-hidden="true" > <span class="icon" aria-hidden="true"> <span class="docon docon-arrow-left"></span> </span> </a> </li> <li> <a type="button" class="is-hidden" data-page="1" aria-label="Page 1 of 977" aria-current="false" 3 href="/en-us/answers/tags/191/sql-server?page=1" > 1 </a> </li> <li class="is-hidden"> <span>...</span> </li> <li> <a data-test-id="pagination-button-1" type="button" class="pagination-link is-current" data-page="1" aria-label="Page 1 of 977" aria-current="true" href="/en-us/answers/tags/191/sql-server?page=1" > 1 </a> </li> <li> <a data-test-id="pagination-button-2" type="button" class="pagination-link " data-page="2" aria-label="Page 2 of 977" aria-current="false" href="/en-us/answers/tags/191/sql-server?page=2" > 2 </a> </li> <li> <a data-test-id="pagination-button-3" type="button" class="pagination-link " data-page="3" aria-label="Page 3 of 977" aria-current="false" href="/en-us/answers/tags/191/sql-server?page=3" > 3 </a> </li> <li> <a data-test-id="pagination-button-4" type="button" class="pagination-link " data-page="4" aria-label="Page 4 of 977" aria-current="false" href="/en-us/answers/tags/191/sql-server?page=4" > 4 </a> </li> <li class=""> <span>...</span> </li> <li> <a type="button" class="pagination-link pagination-next" data-page="977" aria-label="Page 977 of 977" aria-current="true" href="/en-us/answers/tags/191/sql-server?page=977" > 977 </a> </li> <li> <a type="button" data-test-id="pagination-button-forward" class="pagination-next " aria-label="Next" href="/en-us/answers/tags/191/sql-server?page=2" aria-hidden="false" > <span class="icon" aria-hidden="true"> <span class="docon docon-arrow-right"> </span> </span> </a></li> </ul> </nav> </div> </main> </body> <div class="layout-body-footer " data-bi-name="layout-footer"> <footer id="footer" data-test-id="footer" data-bi-name="footer" class="footer-layout has-padding has-default-focus uhf-container" role="contentinfo" > <div class="display-flex gap-xs flex-wrap-wrap is-full-height padding-right-lg-desktop"> <a data-mscc-ic="false" href="#" data-bi-name="select-locale" class="locale-selector-link flex-shrink-0 button button-sm button-clear external-link-indicator" id="" title="" ><span class="icon" aria-hidden="true" ><span class="docon docon-world"></span></span ><span class="local-selector-link-text">en-us</span></a > <div class="ccpa-privacy-link" data-ccpa-privacy-link hidden> <a data-mscc-ic="false" href="https://aka.ms/yourcaliforniaprivacychoices" data-bi-name="your-privacy-choices" class="button button-sm button-clear flex-shrink-0 external-link-indicator" id="" title="" > <svg role="img" aria-label="California Consumer Privacy Act (CCPA) Opt-Out Icon" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 30 14" xml:space="preserve" height="16" width="43" focusable="false" > <title>California Consumer Privacy Act (CCPA) Opt-Out Icon</title> <path d="M7.4 12.8h6.8l3.1-11.6H7.4C4.2 1.2 1.6 3.8 1.6 7s2.6 5.8 5.8 5.8z" style="fill-rule:evenodd;clip-rule:evenodd;fill:#fff" ></path> <path d="M22.6 0H7.4c-3.9 0-7 3.1-7 7s3.1 7 7 7h15.2c3.9 0 7-3.1 7-7s-3.2-7-7-7zm-21 7c0-3.2 2.6-5.8 5.8-5.8h9.9l-3.1 11.6H7.4c-3.2 0-5.8-2.6-5.8-5.8z" style="fill-rule:evenodd;clip-rule:evenodd;fill:#06f" ></path> <path d="M24.6 4c.2.2.2.6 0 .8L22.5 7l2.2 2.2c.2.2.2.6 0 .8-.2.2-.6.2-.8 0l-2.2-2.2-2.2 2.2c-.2.2-.6.2-.8 0-.2-.2-.2-.6 0-.8L20.8 7l-2.2-2.2c-.2-.2-.2-.6 0-.8.2-.2.6-.2.8 0l2.2 2.2L23.8 4c.2-.2.6-.2.8 0z" style="fill:#fff" ></path> <path d="M12.7 4.1c.2.2.3.6.1.8L8.6 9.8c-.1.1-.2.2-.3.2-.2.1-.5.1-.7-.1L5.4 7.7c-.2-.2-.2-.6 0-.8.2-.2.6-.2.8 0L8 8.6l3.8-4.5c.2-.2.6-.2.9 0z" style="fill:#06f" ></path> </svg> <span>Your Privacy Choices</span></a > </div> <div class="flex-shrink-0"> <div class="dropdown has-caret-up"> <button data-test-id="theme-selector-button" class="dropdown-trigger button button-clear button-sm has-inner-focus theme-dropdown-trigger" aria-controls="{{ themeMenuId }}" aria-expanded="false" title="Theme" data-bi-name="theme" > <span class="icon"> <span class="docon docon-sun" aria-hidden="true"></span> </span> <span>Theme</span> </button> <div class="dropdown-menu" id="{{ themeMenuId }}" role="menu"> <ul class="theme-selector padding-xxs" data-test-id="theme-dropdown-menu"> <li class="theme display-block"> <button class="button button-clear button-sm theme-control button-block justify-content-flex-start" data-theme-to="light" > <span class="theme-light margin-right-xxs"> <span class="theme-selector-icon border display-inline-block has-body-background" aria-hidden="true" > <svg class="svg" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 22 14"> <rect width="22" height="14" class="has-fill-body-background" /> <rect x="5" y="5" width="12" height="4" class="has-fill-secondary" /> <rect x="5" y="2" width="2" height="1" class="has-fill-secondary" /> <rect x="8" y="2" width="2" height="1" class="has-fill-secondary" /> <rect x="11" y="2" width="3" height="1" class="has-fill-secondary" /> <rect x="1" y="1" width="2" height="2" class="has-fill-secondary" /> <rect x="5" y="10" width="7" height="2" rx="0.3" class="has-fill-primary" /> <rect x="19" y="1" width="2" height="2" rx="1" class="has-fill-secondary" /> </svg> </span> </span> <span role="menuitem"> Light </span> </button> </li> <li class="theme display-block"> <button class="button button-clear button-sm theme-control button-block justify-content-flex-start" data-theme-to="dark" > <span class="theme-dark margin-right-xxs"> <span class="border theme-selector-icon display-inline-block has-body-background" aria-hidden="true" > <svg class="svg" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 22 14"> <rect width="22" height="14" class="has-fill-body-background" /> <rect x="5" y="5" width="12" height="4" class="has-fill-secondary" /> <rect x="5" y="2" width="2" height="1" class="has-fill-secondary" /> <rect x="8" y="2" width="2" height="1" class="has-fill-secondary" /> <rect x="11" y="2" width="3" height="1" class="has-fill-secondary" /> <rect x="1" y="1" width="2" height="2" class="has-fill-secondary" /> <rect x="5" y="10" width="7" height="2" rx="0.3" class="has-fill-primary" /> <rect x="19" y="1" width="2" height="2" rx="1" class="has-fill-secondary" /> </svg> </span> </span> <span role="menuitem"> Dark </span> </button> </li> <li class="theme display-block"> <button class="button button-clear button-sm theme-control button-block justify-content-flex-start" data-theme-to="high-contrast" > <span class="theme-high-contrast margin-right-xxs"> <span class="border theme-selector-icon display-inline-block has-body-background" aria-hidden="true" > <svg class="svg" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 22 14"> <rect width="22" height="14" class="has-fill-body-background" /> <rect x="5" y="5" width="12" height="4" class="has-fill-secondary" /> <rect x="5" y="2" width="2" height="1" class="has-fill-secondary" /> <rect x="8" y="2" width="2" height="1" class="has-fill-secondary" /> <rect x="11" y="2" width="3" height="1" class="has-fill-secondary" /> <rect x="1" y="1" width="2" height="2" class="has-fill-secondary" /> <rect x="5" y="10" width="7" height="2" rx="0.3" class="has-fill-primary" /> <rect x="19" y="1" width="2" height="2" rx="1" class="has-fill-secondary" /> </svg> </span> </span> <span role="menuitem"> High contrast </span> </button> </li> </ul> </div> </div> </div> </div> <ul class="links" data-bi-name="footerlinks"> <li class="manage-cookies-holder" hidden=""></li> <li> <a data-mscc-ic="false" href="https://learn.microsoft.com/en-us/previous-versions/" data-bi-name="archivelink" class=" external-link-indicator" id="" title="" >Previous Versions</a > </li> <li> <a data-mscc-ic="false" href="https://techcommunity.microsoft.com/t5/microsoft-learn-blog/bg-p/MicrosoftLearnBlog" data-bi-name="bloglink" class=" external-link-indicator" id="" title="" >Blog</a > </li> <li> <a data-mscc-ic="false" href="https://learn.microsoft.com/en-us/contribute" data-bi-name="contributorGuide" class=" external-link-indicator" id="" title="" >Contribute</a > </li><li> <a data-mscc-ic="false" href="https://go.microsoft.com/fwlink/?LinkId=521839" data-bi-name="privacy" class=" external-link-indicator" id="" title="" >Privacy</a > </li><li> <a data-mscc-ic="false" href="https://learn.microsoft.com/en-us/legal/termsofuse" data-bi-name="termsofuse" class=" external-link-indicator" id="" title="" >Terms of Use</a > </li><li> <a data-mscc-ic="false" href="https://aka.ms/msftqacodeconduct" data-bi-name="codeofconduct" class=" external-link-indicator" id="" title="" >Code of Conduct</a > </li><li> <a data-mscc-ic="false" href="https://www.microsoft.com/legal/intellectualproperty/Trademarks/" data-bi-name="trademarks" class=" external-link-indicator" id="" title="" >Trademarks</a > </li> <li>© Microsoft 2024</li> </ul> </footer> </footer> </html>

CINXE.COM

SQL Server - Microsoft Q&A