Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,889 questions
1 answer
Cannot uninstall SQL Server Integration Services Projects after VS version 16.0.0 (offline) update
Hi MS, We got a Visual Studio version 16.0.0 (Offline) and SQL Server Integration Services Projects installed. I updated VS to version 16.11.0 from an offline layout. I moved on to trying to update the SQL Server Integration Services Projects version…
Visual Studio
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,525 questions
Visual Studio Extensions
Visual Studio Extensions
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Extensions: A program or program module that adds functionality to or extends the effectiveness of a program.
194 questions
asked 2024-07-24T06:47:23.6766667+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(76.8, 1%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Mary T
0
Reputation points
commented 2024-07-26T13:04:12.7533333+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, 10%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAX%3C/text%3E%3C/svg%3E)
Anna Xiu-MSFT
27,891
Reputation points Microsoft Vendor
4 answers
After migrating to Windows 11 - Cannot bulk load because the file could not be opened. Operating system error code 5 (Aaccess is denied)
I just moved to a Windows 11 PC and now when using SSMS and I try to do a Bulk Insert into a SQL 2017 database, I get this error. Cannot bulk load because the file could not be opened. Operating system error code 5 (Aaccess is denied) I can do the same…
asked 2024-07-08T18:52:02.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(214.4, 73%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED3%3C/text%3E%3C/svg%3E)
DoveConnieDES-3786
1
Reputation point
commented 2024-07-26T12:53:50.61+00:00
DoveConnieDES-3786
1
Reputation point
0 answers
How to Retrieve SQL Server Instance Details from SQL IaaS Agent Extension Using Azure CLI
Hello Azure Community, I am working with SQL Virtual Machines in Azure and using the SQL Server IaaS Agent Extension to manage my SQL Server instances. In the Azure portal, under the "SQL Virtual Machine" service, I can view detailed SQL Server…
asked 2024-07-26T12:15:01.9433333+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(275.2, 49%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFA%3C/text%3E%3C/svg%3E)
FERNANDO ARTERO SERRANO
0
Reputation points
asked 2024-07-26T12:15:01.9433333+00:00
FERNANDO ARTERO SERRANO
0
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-26T10:13:55.9266667+00:00
Mark van Eck
56
Reputation points
3 answers
One of the answers was accepted by the question author.
SQL Server 2022 - Launchpad - how to eliminate errors in the logs "Failed to delete directory..."
Hi, I'm unable to find a solution to this anywhere and I'm desperate. Perhaps someone faced a similar issue and managed to find a solution. I'm running out of hairs on my head to pull them out. I got installed SQL Server 2022 with latest CU on Windows…
asked 2024-07-25T08:45:40.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(188.79999999999998, 82%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
RandomGuy123
35
Reputation points
edited a comment 2024-07-26T09:17:25.5266667+00:00
RandomGuy123
35
Reputation points
0 answers
Installing IBMi Access Driver on Azure Data Factory Integration Runtime
Hello, I've been trying to install the Windows version of the IBM i Access Driver on a Data Factory Integration Runtime through adding a script (main.cmd) and the desired installer in a Blob Container This script seems to work perfectly locally but when…
asked 2024-07-24T07:19:18.0966667+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(188.79999999999998, 97%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Alexandru Moise
0
Reputation points
commented 2024-07-26T09:11:56.3333333+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(268.8, 8%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Smaran Thoomu
12,620
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
What logs does a full database backup contain?
When restoring a full database backup, restore can use the no_log parameter to not restore logs (although this parameter is officially disabled), and then rebuild the ldf by replacing the mdf with a new library. This can avoid the excessive time required…
![](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(108.80000000000001, 66%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
1 answer
Query stuck with HTDELETE for hours eventually timing out
We have an Azure SQL Database to manage our Customer data. I have a reasonably complicated query that has been getting stuck with an HTDELETE wait. Most recently it timed out after 4 hours. This was in our QA environment. The same query finishes in less…
asked 2024-07-26T00:53:55.72+00:00
Nick Ryan
221
Reputation points
answered 2024-07-26T08:38:41.8633333+00:00
Erland Sommarskog
107.2K
Reputation points
2 answers
One of the answers was accepted by the question author.
Customer Best Practices Assessment: exclude checks/false positives
Is there any way to customize the BPA in Azure ARC for SQL to exclude certain checks or to flag issues as false positives? I've got certain issues being flagged by the BPA however these can't be resolved as the application accessing the database requires…
asked 2024-07-19T09:42:13.16+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(243.2, 0%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBB%3C/text%3E%3C/svg%3E)
Berend Broekhoff
20
Reputation points Microsoft Employee
commented 2024-07-26T08:34:18.6+00:00
Berend Broekhoff
20
Reputation points Microsoft Employee
3 answers
One of the answers was accepted by the question author.
Temp file not shrinking
I have a temp DB file that is not shrinking. Temp DB has 6 mdf files but one is large and not shrinking after multiple attempts. Any idea on how to resolve this? Thanks
asked 2024-07-22T17:55:17.6866667+00:00
Babawale Dawodu
110
Reputation points
accepted 2024-07-26T08:22:56.3566667+00:00
Babawale Dawodu
110
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
commented 2024-07-26T08:19:06.6866667+00:00
Erland Sommarskog
107.2K
Reputation points
3 answers
Materialized View and Left Join
From what I gather: left, right, and outer joins are not allowed in materialized views, nor are unions or group-bys. What I want is to get 3 columns from 1 table, and an additional Min Value from a separate 1:many table. For example: Item (table): Id,…
asked 2024-07-25T18:04:00.1033333+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(0, 48%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDW%3C/text%3E%3C/svg%3E)
David Wright
0
Reputation points
commented 2024-07-26T07:55:42.1533333+00:00
Erland Sommarskog
107.2K
Reputation points
1 answer
One of the answers was accepted by the question author.
I am making a connection to mssql using typeorm and getting error
Hi, I am trying to create connection to my mssql server using typeorm in node 20 application. I am getting socket hang-up error, the connection gets created if I set encrypt to false. I tried all tls configuration and everything but I am not able to…
asked 2024-07-11T13:58:53.66+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(73.60000000000001, 12%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKC%3C/text%3E%3C/svg%3E)
Kasthuri C M
20
Reputation points
commented 2024-07-26T06:29:16.17+00:00
LucyChenMSFT-4874
3,470
Reputation points
2 answers
One of the answers was accepted by the question author.
Failed to Create Maintenance Plan in SQL Server 2019 show Exception from HRESULT: 0xC0014001 (Microsoft.SqlServer.DTSRuntimeWrap)
Hi, I have been trying to create maintenance plan using maintenance plan wizard in SSMS. As i go through the plan, the prompt show error 'Saving maintenance plan failed' with Exception from HRESULT: 0xC0014001 (Microsoft.SqlServer.DTSRuntimeWrap). The…
asked 2024-07-22T06:12:07.33+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(198.4, 57.00000000000001%, 29%)' 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)
Muhammad Danial Nu'man Noorman
20
Reputation points Microsoft Vendor
accepted 2024-07-26T06:27:47.4266667+00:00
Muhammad Danial Nu'man Noorman
20
Reputation points Microsoft Vendor
2 answers
How to create Excel Connection to a SQL database
This connection must be validated by a SQL login to ensure the contents of your databases remain secure. The connection can be refreshed to update the content from the SQL database.
asked 2024-07-18T20:11:35.03+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(172.8, 54%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJJ%3C/text%3E%3C/svg%3E)
Jhon jr
0
Reputation points
commented 2024-07-26T05:35:11.9533333+00:00
LucyChenMSFT-4874
3,470
Reputation points
2 answers
Application unable to connect to Listener intermittently on port 1433
We have a named instance that's running on a dynamic port, with a Listener specified on port 1433. All application strings only specify the listener IP and port. A scheduled job connects to the listener once a day, but it sometimes fails with the error…
asked 2024-07-21T04:05:37.09+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(147.20000000000002, 43%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Amisha Bhadauria
0
Reputation points
commented 2024-07-26T05:34:04.25+00:00
LucyChenMSFT-4874
3,470
Reputation points
2 answers
How can I find my SQL server License to upgrade Report Server Configuration Manager
Our version of Report Server Config Manager is on Evaluation. We license an Azure sql server from Office365 but I cannot find the license key. I need to upgrade the RSCM but it's requiring a key.
asked 2024-07-22T16:24:00.86+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(108.80000000000001, 75%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Mt Rose Administrator
0
Reputation points
commented 2024-07-26T05:32:40.5133333+00:00
LucyChenMSFT-4874
3,470
Reputation points
2 answers
OS and SQL server upgrade
What could be the best upgrade plan for MS SQL server 2012 and Windows server 2012?
asked 2024-07-23T12:00:18.7866667+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(214.4, 35%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
AJCV
0
Reputation points
commented 2024-07-26T05:31:54.3+00:00
LucyChenMSFT-4874
3,470
Reputation points
2 answers
SQL audit (Server audit specification > SERVER_STATE_CHANGE_GROUP) log sa user instead DOMAIN\USERNAME
Hi all, I am testing audit for SQL Server currently running on a IAAS VM (Win server 2022, SQL Server 2022 CU14). I have created an audit which log file in a file. I have created a Server audit specification which include the action…
asked 2024-07-25T17:04:58.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(179.20000000000002, 18%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAC%3C/text%3E%3C/svg%3E)
Alessandro Colombi
0
Reputation points
answered 2024-07-26T03:45:59.8566667+00:00
MikeyQiaoMSFT-0444
1,925
Reputation points
2 answers
SQL server bulk insert for multiple csv files from a single folder. I want store each file as each table at a time I want insert 10 csv and txt files on SQL server. Please provide me any SQL script.
SQL server bulk insert for multiple csv files from a single folder. I want store each file as each table at a time I want insert 10 csv and txt files on SQL server. Please provide me any SQL script.
asked 2024-07-25T10:02:43.56+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(153.6, 38%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
nn
20
Reputation points
answered 2024-07-26T01:48:23.69+00:00
LiHongMSFT-4306
25,651
Reputation points