SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,330 questions
1 answer
how to enable the Integration Services Catalogs node
I dont see the "Integration Services Catalogs"node option in my sql sever connection. how to enable this option in my server. i installed the developer edition and also have sql integration service
asked 2024-07-22T02:44:00.19+00:00
![](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(233.6, 5%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPU%3C/text%3E%3C/svg%3E)
Padmanaban U
0
Reputation points
answered 2024-07-22T06:06:27.76+00:00
ZoeHui-MSFT
35,381
Reputation points
1 answer
One of the answers was accepted by the question author.
SQL Inner Join Multiple Value
Hello, I have 2 tables like below : Table 1 ID Name IP 1 SERVER-A 10.10.10.1 2 SERVER-B 10.10.10.2 Table 2 ID Mac Speed 1 0000.1111.2222 1000 1 …
asked 2024-07-22T04:23:55.98+00:00
Handian Sudianto
4,471
Reputation points
accepted 2024-07-22T05:07:01.5933333+00:00
Handian Sudianto
4,471
Reputation points
2 answers
How to access database by External Datasource using Service Principal Name(SPN)
I am seeking a solution for cross-database access via an external data source using Service Principal credentials. Specifically, I want to perform Transact-SQL queries from one database to another using Service Principal credentials. To achieve this, I…
asked 2024-07-21T14:42:53.0533333+00:00
![](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(67.2, 65%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
Devendra Parmar
0
Reputation points
commented 2024-07-22T04:12:37.85+00:00
Devendra Parmar
0
Reputation points
2 answers
Questions about always on’s data synchronization method
Hello I am curious about data synchronization of secondary in always on. Secondary confirmed that the redo thread reads the log cache or redo log file and synchronizes it to the data file and index file. I have doubts about the synchronization method…
asked 2024-07-20T04:10:57.85+00:00
![](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(70.4, 68%, 16%)' 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)
MINJAE KO
0
Reputation points
answered 2024-07-22T03:14:24.7866667+00:00
MikeyQiaoMSFT-0444
1,755
Reputation points
1 answer
Protocol Error in TDS Stream in SSIS - connected host has failed to respond
Hello, We are having issue when we are running SSIS package and getting following error: Code: 0xC0202009 Source: Sync Details Data FLow sqlssis OLE DB Source [1] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error…
asked 2024-07-21T00:17:48.94+00:00
![](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, 78%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Pds
46
Reputation points
answered 2024-07-22T02:18:33.32+00:00
ZoeHui-MSFT
35,381
Reputation points
3 answers
Discrepancy in results when running TSQL query with iif
Hi, SQL server version: running on Azure Sql Database 12.0.2000.8 RTM SQL Azure DB compatibility level 160 I am getting discrepancy with the following results, the same thing with case statement, and with patindex. declare @inputString nvarchar(max)…
asked 2024-07-20T16:53:49.1566667+00:00
![](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(19.2, 42%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Mansa
0
Reputation points
answered 2024-07-22T01:39:29.54+00:00
LiHongMSFT-4306
25,651
Reputation points
4 answers
SQL Statement taking long to execute
I have two SQL Databases that is on the same SQL server but on one database it only takes 4 seconds to complete the SQL statement but on the other SQL database it takes 25 minutes to complete. Both databases uses the same SQL elastic pool and I don't see…
asked 2024-07-15T03:15:50.06+00:00
![](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, 75%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWS%3C/text%3E%3C/svg%3E)
WingHong Shiu
5
Reputation points
answered 2024-07-21T20:58:04.8166667+00:00
Erland Sommarskog
106.5K
Reputation points
9 answers
unable to install sql server exit code -2068052377
I was using 2018 ssms with sql server and it worked up to a few days ago. I've tried several ways to fix this. I ran repair setup and goes thru the repair but still have the issue. I uninstall and reinstall. I check service.msc and and tried to…
asked 2022-07-05T15:16:37.617+00:00
![](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(284.8, 28.999999999999996%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
John Burks
11
Reputation points
commented 2024-07-21T20:14:16.7266667+00:00
Erland Sommarskog
106.5K
Reputation points
3 answers
Visio Professional 2019 Currently selected visio driver is not compatible with data source.
I am using brand new copy of Visio Professional 2019, and SQL Server version 15.0.2080.9, both installed on a stand-alone Windows 10 machine. I am using the Reverse Engineering wizard. No matter what ODBC driver I select, or what level DSN it is…
asked 2021-04-19T01:10:48.14+00:00
![](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(179.20000000000002, 86%, 27%)' 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)
jchatton1
6
Reputation points
commented 2024-07-21T12:25:27.01+00:00
![](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(156.8, 75%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Roger Schmidt
16
Reputation points
2 answers
Recover Resource Group and SQL Server and SQL DB within
I deleted an old Resourge Group with SQL DB within, can i recover within Azure Portal? We have no Backups.
asked 2024-04-22T14:16:11.3833333+00:00
![](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(281.6, 97%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
Helpdesk Milestone
0
Reputation points
commented 2024-07-21T10:15:11.4366667+00:00
Vinodh247
13,301
Reputation points
3 answers
Unable to connect to my SQL Server/Database. Listed resources on Microsoft do not address this issue.
Error codeSqlFailedToConnect DetailsCannot connect to SQL Database. Please contact SQL server team for further support. Server: 'blazor-wasm-app.database.windows.net', Database: 'BrandedFoodMacrosContent', User: [...BLANK...] Check the linked service…
asked 2024-05-04T23:34:12.1833333+00:00
![](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, 44%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Albert Kirpach
0
Reputation points
commented 2024-07-21T10:14:26.0166667+00:00
Vinodh247
13,301
Reputation points
5 answers
One of the answers was accepted by the question author.
SQL Server 2019 Maintenance Plan Tasks Toolbox Missing
Unable to add tasks to new maintenance plan because there is no Maintenance Plan Toolbox. How can we create or recover this Toolbox? This is a new install of SQL 2019 and first time adding maintenance plan on this server.
asked 2022-03-25T18:23:12.08+00:00
![](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(220.8, 0%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJR%3C/text%3E%3C/svg%3E)
John Robinson
26
Reputation points
answered 2024-07-21T05:27:04.0533333+00:00
![](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(249.60000000000002, 85%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERE%3C/text%3E%3C/svg%3E)
RUPERT EDANG
0
Reputation points
5 answers
One of the answers was accepted by the question author.
Is there a 64 bit SSMS?
I‘ve already downloaded and installed SQL Server and SSMS on my computer and then I noticed that the SSMS running on my computer is a 32-bit program. I wonder if there a 64-bit SSMS, for I didn't find it anawhere, including the MicroSoft offical webpage.…
asked 2021-09-29T11:48:06.173+00:00
子明 李
21
Reputation points
commented 2024-07-21T01:35:57.8133333+00:00
![](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)
Yitzhak Khabinsky
25,726
Reputation points
2 answers
Bacpac file won't restore due to columnstore indexes on columns with specific data types.
Situation: We are using Serverless Azure SQL Databases as projects. Afterwards we delete these databases but before we do that we create backups of the databases. We are using SqlPackage.exe (version: 162.3.566) to create bacpac files. Restoring bacpac…
asked 2024-07-19T09:58:51.94+00:00
![](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, 99%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMV%3C/text%3E%3C/svg%3E)
Mark van Eck
56
Reputation points
commented 2024-07-20T21:38:15.0566667+00:00
Erland Sommarskog
106.5K
Reputation points
0 answers
Server infected with arthur virus
Server infected with arthur virus. all file extensions are with ,arthur . I need help knowing if I can access data from another server, I am currently on "East US 2" and want to use the "west us" backup. What recommendations do you…
asked 2024-07-20T15:55:46.3166667+00:00
![](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(291.2, 74%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
Victor
0
Reputation points
commented 2024-07-20T21:19:31.2266667+00:00
Erland Sommarskog
106.5K
Reputation points
0 answers
MY SQL SERVER INSTALLATION ERROR
Hello everyone, I'm currently on Win11 Pro 23H2. I have installed and uninstall My SQL express couple times but having no luck in success installation. I didn't know the cause of this issue. Hope you guys could get me a possible fix Thank you and Best…
asked 2024-07-19T14:04:23.9566667+00:00
![](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(262.40000000000003, 45%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
Đình Khoa
0
Reputation points
commented 2024-07-20T21:12:22.8433333+00:00
Erland Sommarskog
106.5K
Reputation points
1 answer
SQL Server 2022 Developer Edition failing install with error code -2068052310
I'm trying to install SQL Server 2022 Developer Edition and am getting an error stating that an installation package for the product Microsoft OLE DB Driver for SQL Server cannot be found and giving me the exit code -2068052310. I've downloaded and…
asked 2023-11-12T03:58:22.8866667+00:00
![](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(60.8, 11%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAV%3C/text%3E%3C/svg%3E)
Angel Van de Feniks
1
Reputation point
commented 2024-07-20T15:27:18.3333333+00:00
Chris Smith
10
Reputation points
1 answer
One of the answers was accepted by the question author.
Server container is always restarting
We are deploying our backend using an Azure web app. We decided not to use serverless Azure Functions based on our experience with Firebase functions, as they usually do not allow file uploads within the same application. On Azure, the problem is that…
asked 2024-07-09T10:10:39.21+00:00
![](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(134.4, 40%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAF%3C/text%3E%3C/svg%3E)
Adeola Folarin
20
Reputation points
accepted 2024-07-20T11:26:04.6333333+00:00
Adeola Folarin
20
Reputation points
1 answer
How to talk to a SQL Database in Azure Gov from a Teams chat?
How alk to a SQL Database in Azure Gov from a Teams chat?
asked 2024-07-19T18:49:00.4066667+00:00
![](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(278.4, 99%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
johon sahu
0
Reputation points
answered 2024-07-19T21:39:02.86+00:00
Erland Sommarskog
106.5K
Reputation points
1 answer
Cannot create and start Extended Events session in Azure SQL Managed Instance
Hello, I am trying to create an Extended Events session in Azure SQL Managed Instance. First I am trying to use SSMS GUI: Extended Events -> Sessions -> New Session... Add "error_reported" event, configure fields, select Data Storage as…
asked 2024-06-24T15:08:42.51+00:00
![](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, 60%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAV%3C/text%3E%3C/svg%3E)
Aleksey Vitsko
20
Reputation points
commented 2024-07-19T21:34:10.5+00:00
Aleksey Vitsko
20
Reputation points