SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,803 questions
1 answer
Import an Excel spreadsheet into SQL
How do I import an Excel spreadsheet into SQL STudio
SQL Server Integration Services
asked 2026-08-11T07:54:32.2+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(44.800000000000004, 73%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIJ%3C/text%3E%3C/svg%3E)
Ian Jones
0
Reputation points
answered 2026-08-11T07:54:52.39+00:00
AI answer
2 answers
how enable de Analysis Service in SQL server ?
I install SQL Server but the Analysis Service is disable, How active this service?
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,376 questions
asked 2026-08-10T23:03:45.0366667+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(112.00000000000001, 75%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJA%3C/text%3E%3C/svg%3E)
Jeyner Alfaro
0
Reputation points
answered 2026-08-11T07:08:50.7866667+00:00
Erland Sommarskog
136.2K
Reputation points MVP
Volunteer Moderator
0 answers
In Microsoft SQL Server 2019, is "MS_DataCollectorInternalUser" an internal Microsoft SQL Server database principal in the msdb system database, required for SQL Server Data Collector functionality?
In Microsoft SQL Server 2019, is "MS_DataCollectorInternalUser" an internal Microsoft SQL Server database principal in the msdb system database, required for SQL Server Data Collector functionality?
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,790 questions
asked 2026-08-11T05:59:13.6733333+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, 15%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERO%3C/text%3E%3C/svg%3E)
R.O
0
Reputation points
1 answer
new ssms installation took so much space
Why new SQL Server Management Studio (22) using visual studio installation took more space than SQL Server Management Studio 20? Is there a lightweigth offline installation package?
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,790 questions
asked 2026-08-11T01:18:49.45+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(128, 98%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELH%3C/text%3E%3C/svg%3E)
Longsheng Hu
0
Reputation points
answered 2026-08-11T05:48:47.62+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(9.6, 52%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Senthil kumar
1,890
Reputation points
0 answers
SSAS 2019 Tabular Processing Issue
Issue Summary: We are experiencing intermittent failures while processing a SQL Server Analysis Services (SSAS) 2019 Tabular model. Environment: Microsoft SQL Server 2019 (RTM-CU32-GDR) (KB5102335) 15.0.4480.2 (X64) Enterprise Edition: Core-based…
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,376 questions
asked 2026-08-10T19:46:45.5933333+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(128, 84%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJO%3C/text%3E%3C/svg%3E)
João Gabriel Sczczepaniak Alves
0
Reputation points
asked 2026-08-10T19:46:45.5933333+00:00
João Gabriel Sczczepaniak Alves
0
Reputation points
1 answer
keep getting random errors everytime i try to restore a database
Hello, I would love to have some remote assistance with my issue. I'm trying to restore a database from an old computer to a new one, but the old computer is on version 12 and any new computer I try to use wants me to upgrade to version 22, and I keep…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
758 questions
asked 2026-08-10T15:54:44.6833333+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(121.6, 18%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAN%3C/text%3E%3C/svg%3E)
Alex Negrich
0
Reputation points
edited an answer 2026-08-10T18:43:54.4133333+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(35.2, 63%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDD%3C/text%3E%3C/svg%3E)
Deepesh Dhake
820
Reputation points
2 answers
AUTOMATIC_TUNING
i got this error when run the alter statement in sql server standard edition 2017 and above version on-premises environment, Note that querystore already enabled without any issues ALTER DATABASE current SET AUTOMATIC_TUNING (FORCE_LAST_GOOD_PLAN =…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
758 questions
asked 2026-08-10T11:28:43.99+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, 63%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Alagarsamy Sundararajan
0
Reputation points
edited the question 2026-08-10T12:16:51.6766667+00:00
Erland Sommarskog
136.2K
Reputation points MVP
Volunteer Moderator
2 answers
How to find and replace table name changes in stored procedures
I have create a SQL database with several tables and some stored procedures. Now I want to change the name of some of the tables. How can I get it to find and replace the changed table name in the stoed procedures
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
758 questions
asked 2026-08-10T03:21:27.73+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(121.6, 40%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Michael Boahene
0
Reputation points
answered 2026-08-10T06:59:47.63+00:00
Erland Sommarskog
136.2K
Reputation points MVP
Volunteer Moderator
0 answers
This backend version is not supported to design database diagrams or tables. (MS Visual Database Tools)
When I create a table in SQL, after right-clicking on the table name and selecting the design option, it gives this error: This backend version is not supported to design database diagrams or tables. (MS Visual Database Tools)
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,790 questions
asked 2026-08-08T08:47:28.6033333+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, 21%, 25%)' 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)
maryA
0
Reputation points
commented 2026-08-09T12:13:14.2733333+00:00
Erland Sommarskog
136.2K
Reputation points MVP
Volunteer Moderator
2 answers
sql server management studio 2018 user setup
how to set up user account and login for sql server management studio 2018 and connect to database
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
758 questions
asked 2026-07-06T22:12:14.9133333+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(44.800000000000004, 30%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Candace Snipes
20
Reputation points
commented 2026-08-09T02:25:21.9866667+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(118.4, 51%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGC%3C/text%3E%3C/svg%3E)
Ganesh Chelluri
190
Reputation points Microsoft External Staff
Moderator
1 answer
Updating Dynamics GP 2018 generates "The stored procedure smGrantAccessOnAccountMSTR returned the following results: DBMS: 0 Microsoft Dynamics GP:" while updating our company database.
We have been attempting to upgrade our Dynamics GP version 18.5.1596 (2002) to version 18.8.1957 (2026). After installing the msp file, we run the GP 2018 Utilities application to update the databases. The DYNAMICS database completes, and then it moves…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,790 questions
asked 2026-08-07T23:58:19.6466667+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(105.60000000000001, 98%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
Randall Baker
0
Reputation points
answered 2026-08-08T07:07:58.1166667+00:00
Erland Sommarskog
136.2K
Reputation points MVP
Volunteer Moderator
1 answer
SQL server 2025 training
Hi Team, We are looking for SQL Server 2025 training for our Database Administration team. Could you please share: Available SQL Server 2025 training programs Course content and duration Virtual and instructor-led options Team pricing for…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
758 questions
asked 2026-08-04T14:05:26.3633333+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, 28.000000000000004%, 23%)' 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)
ashutosh
0
Reputation points
recommended 2026-08-07T20:59:04.0133333+00:00
Erland Sommarskog
136.2K
Reputation points MVP
Volunteer Moderator
2 answers
One of the answers was accepted by the question author.
Unable to access SQL Database for Get data in Power BI Lab
I am having trouble connecting to the SQL database in the first Lab. To complete the Get data in Power BI Lab, I must have access to SQL Server. I keep getting an error message when I try to open SQL Server in Power BI. I get this error message…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,790 questions
asked 2026-08-07T19:33:18.0866667+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, 19%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKD%3C/text%3E%3C/svg%3E)
Kennedy Davis
20
Reputation points
accepted 2026-08-07T20:55:54.4466667+00:00
Kennedy Davis
20
Reputation points
2 answers
How to stop my query editor from closing on its own
I'm constantly getting a pop up asking me to save queries I am still working on. Sometimes I open an instance that has been idle just to realize the query I had open has been closed or disappeared. Plus I have checked the copy with header option in the…
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,175 questions
asked 2026-08-06T17:19:36.4333333+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(3.2, 1%, 10%)' 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)
Tameka
0
Reputation points
answered 2026-08-07T15:09:38.1766667+00:00
Deepesh Dhake
820
Reputation points
2 answers
Database refresh from Production to Dev
We want to restore some databases from Production server to Dev server. We want to create a job that automatically restores a fresh copy of these databases to Dev server on 10th of each month. Could you please advise on how to do this.
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
758 questions
asked 2026-08-06T19:39:45.92+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(304, 63%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECK%3C/text%3E%3C/svg%3E)
Chaitanya Kiran
841
Reputation points
commented 2026-08-07T14:16:35.41+00:00
Deepesh Dhake
820
Reputation points
6 answers
One of the answers was accepted by the question author.
AdventureWorksDW2020 DB is missing a table
Hi, I'm trying to go through the PowerBI lab at this url: https://learn.microsoft.com/en-gb/learn/modules/get-data/lab-prepare I downloaded the AdventureWorksDW2020 from GitHub and loaded into SQL server management studio. 6 tables are…
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,175 questions
asked 2020-10-18T18:54:21.503+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(230.39999999999998, 90%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPO%3C/text%3E%3C/svg%3E)
Philip O'Donnell
26
Reputation points
commented 2026-08-07T06:46:15.92+00:00
Acram Twaib
0
Reputation points
3 answers
Issue in the Installing the SQL Server
Hi Team, I'm using the Window 11 OS and the Processor - Intel(R) Core(TM) i3-10110U CPU @ 2.10GHz, 2592 Mhz, 2 Core(s), 4 Logical Processor(s). When i tried to install Microsoft SQL I was getting this error, please help me to resolve the issue.
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
758 questions
asked 2026-07-30T17:17:19.8333333+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(16, 59%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDK%3C/text%3E%3C/svg%3E)
Dhivya Krishnan
0
Reputation points
commented 2026-08-06T10:07:23.5733333+00:00
Dhivya Krishnan
0
Reputation points
1 answer
SQL LICENSE
I have a product key, and I'd like to know what type of license it corresponds to.
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,790 questions
asked 2026-08-06T08:16:21.9333333+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, 98%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELF%3C/text%3E%3C/svg%3E)
Luca Facchetti
0
Reputation points
commented 2026-08-06T09:38:53.4066667+00:00
Luca Facchetti
0
Reputation points
1 answer
SSIS installed on Azure Marketplace SQL Server 2025 VM, but SSIS Catalog components are missing
I deployed a VM from the Azure Marketplace image: Publisher: microsoftsqlserver Offer: sql2025-ws2025 Plan: standard-gen2 Environment: SQL Server Version Microsoft SQL Server 2025 (RTM-CU7) (KB5096981) 17.0.4065.4 (X64) Standard Edition SSMS…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,803 questions
asked 2026-08-05T09:05:51.61+00:00
Kris Reynolds
0
Reputation points
edited the question 2026-08-05T09:37:04.7+00:00
Erland Sommarskog
136.2K
Reputation points MVP
Volunteer Moderator
1 answer
how to override the database selected in the available database dropdown
I need to union results from two databases using fully qualified objects/views but the query after the union returns zero rows.
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,790 questions
asked 2026-08-04T13:37:55.46+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, 6%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELP%3C/text%3E%3C/svg%3E)
Lindbom, Peter
0
Reputation points
answered 2026-08-04T21:18:20.71+00:00
Erland Sommarskog
136.2K
Reputation points MVP
Volunteer Moderator