SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,139 questions
2 answers
update all DB
I want to update the cells with the value "ABCD" to "XYZW" in all tables in the DB.
asked 2024-06-25T07:56:42.12+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(64, 95%, 16%)' 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)
ahmet sincar
1
Reputation point
answered 2024-06-25T11:22:27.8133333+00:00
Greg Low
1,650
Reputation points Microsoft Regional Director
2 answers
How to update the activation of SQL Server?
Dear All, We have an open value agreement and recently we have added an extra SQL license to the agreement. First, we purchased a license for 4 cores then we added 4 cores. Now, how can we use these new extra SQL Server licenses on the existing SQL…
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,139 questions
Windows Licensing
Windows Licensing
Windows: A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.Licensing: Rules, regulations, and restrictions that define how software can be used and distributed.
51 questions
asked 2024-06-19T14:05:36.9733333+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(99.2, 84%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHA%3C/text%3E%3C/svg%3E)
Haitham Al-Haj
20
Reputation points
commented 2024-06-25T11:16:18.2466667+00:00
Haitham Al-Haj
20
Reputation points
0 answers
SQL Server data import connection issue
I am getting the following error message when trying to import data from an excel spreadsheet. [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (Microsoft OLE DB Provider for SQL Server) I am running SSMS v20.1 on…
asked 2024-06-25T10:36:57.11+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, 16%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKB%3C/text%3E%3C/svg%3E)
Keith Banbury
0
Reputation points
asked 2024-06-25T10:36:57.11+00:00
Keith Banbury
0
Reputation points
1 answer
There was an error trying to establish an Oracle connection with the database server
TITLE: Microsoft Visual Studio There was an error trying to establish an Oracle connection with the database server. Getting this error while trying to establish connection to Oracle is SSIS ConnectionManager. Tried to connect using…
asked 2024-06-21T15:03:49.6566667+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, 47%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
Jobin, Priscilla
0
Reputation points
answered 2024-06-25T10:00:32.91+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(307.2, 44%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
Claudia Dos Santos Haz (CONCENTRIX CORPORATION)
855
Reputation points Microsoft Vendor
1 answer
Azure Data Factory: Copy Data Activity: "Schema import failed: Please select a table"
Hello! I am pretty new to Azure Data Factory and trying to build my first data pipeline. So far, I have managed to install an integration run time in my PC and established a connection to the on prem SQL server. I have tested the connection and it says…
asked 2024-06-22T10:16:15.37+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, 22%, 30%)' 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)
Bhargav
5
Reputation points
commented 2024-06-25T09:44:14.7333333+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
11,775
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
SCCM Database Replication
Hello, There is link degraded between CAS and Primary. spdiagdrs output shows that some replication groups are under degraded state. Please help to understand this replication and degradation. Share any article to read about the same. How to solve this…
asked 2024-06-24T11:12:30.59+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, 63%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Boopathi Subramaniam
3,241
Reputation points
accepted 2024-06-25T09:12:30.8933333+00:00
Boopathi Subramaniam
3,241
Reputation points
1 answer
Why not parallelism
select * from yieldtransit cost threshold for parallelism run_value = 1 max degree of parallelism run_value = 0 StatementSubTreeCost = 42.1767 sqlplan.xml
![](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)
2 answers
MS SQL express compare to MS SQL Server Enterprise
Hello, where to find compare of the fuctionalities for MS SQL Express 2019 vs Express 2022 vs Express 2024 vs MS SQL Server Enterprise 15.0.4360.2? Thank you in advance.
asked 2024-06-21T07:28:51.2166667+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(28.799999999999997, 10%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Salka, Milan
21
Reputation points
commented 2024-06-25T08:27:29.96+00:00
LucyChenMSFT-4874
2,570
Reputation points
2 answers
Execution Timeout Expired Error with UPS API Request in SQL Server 2019 Backend
Hello everyone, I'm encountering an issue with a web backend application that uses SQL Server 2019. We send a request to the UPS API, but it fails, and the application error log shows the following message: LOGGER Error: 0 : 6/14/2024 2:45:38 PM :…
asked 2024-06-21T07:34:58+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(28.799999999999997, 62%, 12%)' 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)
Vinith
25
Reputation points
commented 2024-06-25T08:26:42.8433333+00:00
LucyChenMSFT-4874
2,570
Reputation points
4 answers
should i make as many datafiles for temdb as many cpus i have.
hi, q1 As people said if u ghave GAM conention then u can go for adding as many datafiles of equal size in temdb as many cpus u have is it correct in sqlserver 2019 vesion also. q2) right click on sqlserver instance then select…
asked 2024-06-23T09:07:08.07+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(41.6, 42%, 14%)' 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)
Rajesh Kumar Yadav
0
Reputation points
answered 2024-06-25T08:15:33.2366667+00:00
Rajesh Kumar Yadav
0
Reputation points
0 answers
Sharepoint DB server "The target principal name is incorrect. Cannot generate SSPI context"
I received the above error message when I access Central admin from the app and web front end (WFE) servers. Upon looking into the issue, it's with regards authentication issue with the DB server. Kerberos authentication was not configured. This error…
0 answers
SharepointListSource Issue in SSIS when Deploymed on SQL Server 2019
Hello, i have an SSIS Package project that was designed in 2015 and was working fine and deployed on the windows server 2012 R2 targeting SQL Server 2014.Now we are migrating to windows server targeting SQL Server 2019.I took the package and opened it in…
asked 2024-06-21T15:50:35.61+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(236.8, 96%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETM%3C/text%3E%3C/svg%3E)
Tumo Maraisane
0
Reputation points
edited the question 2024-06-25T06:29:04.4266667+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(64, 85%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJX%3C/text%3E%3C/svg%3E)
Jiale Xue - MSFT
41,736
Reputation points Microsoft Vendor
0 answers
Sharepoint DB server "The target principal name is incorrect. Cannot generate SSPI context"
I found the above error when I attempt to access Central admin from the app and web front end servers. No configuration was done to use Kerberos authentication was used. Past activity done before the error occurred was rejoining the DB server back to…
asked 2024-06-25T04:24:40.1433333+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(163.2, 17%, 25%)' 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)
Azim
6
Reputation points
edited the question 2024-06-25T06:19:48.1866667+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, 82%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELZ%3C/text%3E%3C/svg%3E)
Ling Zhou_MSFT
14,610
Reputation points Microsoft Vendor
2 answers
How to fix SSMS Import Excel Microsoft.ACE.OLEDB.16.0 provider is not registered error
I got a new laptop at work, and after installing SSMS (old and new versions), when I try to use the import wizard to import from an Excel spreadsheet, I get the error message The Microsoft.SCE.OLEDB.16.0 provider is not registered on the local machine. …
asked 2024-06-24T19:30:43.4933333+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, 81%, 25%)' 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)
Patricia Ortiz
0
Reputation points
answered 2024-06-25T05:46:53.1166667+00:00
ZoeHui-MSFT
34,591
Reputation points
2 answers
Installing Security Update for Microsoft ODBC Driver 17 and SQL OLE DB Driver
I've downloaded the SQL Driver and OLE DB driver 9th April 2024 and have attempt to install by running as admin and powershell command. Powershell command "Start-Process -FilePath "C:\Temp\security-package.exe" -Wait" I have…
2 answers
Trouble importing data using SQL Server Import and Export Wizard
I tried the SQL Server Import and Export Wizard and have the following issues: Importing using Excel File When I imported using Excel File, this following message displayed. I already installed the OLE DB but it still did not work Import using Flat…
asked 2024-06-24T03:35:22.9066667+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(195.2, 8%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHB%3C/text%3E%3C/svg%3E)
Huyen Bui
0
Reputation points
answered 2024-06-25T04:42:15.85+00:00
yunus emre ISIK
181
Reputation points
0 answers
Analysis Service very slow to connect in SQL Management Studio
Hi all, I have a SQL Server, SSAS and SQL Server Management Studio installed on the same PC. Connecting to the SQL Database Engine in SSMS is very fast. However, connecting to SSAS in SSMS is excruciatingly slow, even though it is just a localhost…
asked 2024-06-25T04:30:15.7066667+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(57.599999999999994, 13%, 15%)' 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)
Norman K. F. Chow
80
Reputation points
asked 2024-06-25T04:30:15.7066667+00:00
Norman K. F. Chow
80
Reputation points
2 answers
One of the answers was accepted by the question author.
SQL Sever migration - SQL 2014 to 2022
Checking on migration option for SQL Server upgrade from SQL 2014 to SQL 2022. Installing separately 2022 in the same server and move the DBs & setups to the new Server. It is mentioned here, that "System databases can be restored only from…
asked 2024-06-24T06:12:54.36+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, 75%, 16%)' 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)
Radhai Krish
161
Reputation points
accepted 2024-06-25T04:27:33.86+00:00
Radhai Krish
161
Reputation points
4 answers
Data (of 15GB) from SQL 2000 to SQL 2012 via SQL 2008 - Express okay? Trial versions?
I'm trying to move a backup data (of 15gb) from SQL 2000 to SQL 2012. To do so, I must go thru SQL 2008 (or 2005), that is, A. Restore 2000-backup-file into 2008. B. Create 2008-backup-file. C. Restore 2008-backup-file into 2012. I've been looking for…
![](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, 69%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
2 answers
VS2017 - SSIS Project
Hello Team, We are using VS2017 with SSDT installed (PFB the screenshot) We cannot find BI projects, unable to create SSIS projects. Please advice. Regards, Nagesh CL
Azure SQL Database
Azure SQL Database
An Azure relational database service.
5,319 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,576 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,793 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,496 questions
asked 2024-06-24T16:16:33.29+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, 53%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENC%3C/text%3E%3C/svg%3E)
Nagesh CL
621
Reputation points
answered 2024-06-25T01:39:01.28+00:00
ZoeHui-MSFT
34,591
Reputation points