SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,153 questions
0 answers
java error pointing to SQL Server
Hi All, Application team is getting below error and they wanted to check if there is an issue from the database end. We didn't find anything from the database end. Nothing in the sql errorlogs nor we see any blocking. Is it really a database error or…
![](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, 13%, 16%)' 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)
0 answers
Major version upgrade to MySQL 8.0 from 5.7: Fails validation process with error "Usage of removed functions" but it doesn't show any detail on what functions are failing.
I am trying to upgrade my Azure MySQL from 5.7 to 8.0 version. I am following the current guide: https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-upgrade The problem is that it doesn't specify which functions are failing or the…
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,057 questions
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,153 questions
asked 2024-06-27T11:26:24.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(208, 6%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBK%3C/text%3E%3C/svg%3E)
Binal Kagathara (Crest Data Systems Private Lim)
0
Reputation points Microsoft Vendor
asked 2024-06-27T11:26:24.4133333+00:00
Binal Kagathara (Crest Data Systems Private Lim)
0
Reputation points Microsoft Vendor
0 answers
SQL Server 2019 - 100% CPU and high waits after job execution
We have a job running on our SQL Server 2019 which is calculating some customer statistics. Every now an then, after the job finished, the CPU usage increases to the maximum and is not resolving until a failover to the secondary node is done. The job…
asked 2024-06-27T11:04:32.5166667+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(185.6, 50%, 27%)' 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)
Patrick Hackl
0
Reputation points
asked 2024-06-27T11:04:32.5166667+00:00
Patrick Hackl
0
Reputation points
0 answers
Find all the path between two nodes of Azure SQL database
I wan to get columns from association table in SELECT caluse , Is there any other way around for this? SELECT subgraph, subgraph as name, EntityTypecode ,aid,adisplaynbr FROM ( SELECT i1.EntityTypecode AS EntityTypecode, i1.EntityAssociationID…
![](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(310.4, 9%, 40%)' 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)
0 answers
Data Flow Cannot Support Error Redirection When Used in a Transaction Error
Hello, I'm attempting to leverage the built-in Transaction functionality but to no avail. I followed the MSFT Learn docs and enabled MSDTC on the database server (same server SSIS is running on). …
![](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, 10%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
0 answers
SSMA for DB2 to SQL migration errors - No Authorized routine named 'getvariable' of type 'Function' having compatible arguments was found.
While connecting to DB2 using SSMA getting below eeror : Error occured while collecting data . [Db2/LINUXX8664] SQL0440N No authorized routine named 'GetVariable" of type "Function" having compatible arguments was found. SQLSTAE-42884
asked 2024-06-25T15:27:36.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(220.8, 73%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPR%3C/text%3E%3C/svg%3E)
Pinky Rajan
0
Reputation points
asked 2024-06-25T15:27:36.86+00:00
Pinky Rajan
0
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
0 answers
SQLPackage no longer revokes permissions on object when removed. How do I do that again?
Using SQLPackage we create a Deployment Script and a Rollback Script using DacPac's We have a Current Dacpac of what the current production server contains and then we have a Dacpac created out of Visual Studio with what it is currently. We create…
![](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(48, 97%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
0 answers
Warning: SSIS Error Code DTS_W_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.
This is the error message I receive when I run a SSIS package. Only one particular server is causing this issue other servers are connecting and package is getting executed. Warning: SSIS Error Code DTS_W_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. …
asked 2024-06-19T02:01:51.49+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, 93%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENJ%3C/text%3E%3C/svg%3E)
Noopura Jaiswal
0
Reputation points
asked 2024-06-19T02:01:51.49+00:00
Noopura Jaiswal
0
Reputation points
0 answers
Best Practices Assessment for Azure-Arc SQL Server
Hi Team, We need to enable Best Practices Assessment (BPA) feature for azure arc enabled SQL servers in 2 subscriptions. What access at what scope is required for enabling this. I have contributor role at subscription level for one and could select the…
asked 2024-06-14T14:27:48.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(256, 69%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES1%3C/text%3E%3C/svg%3E)
SujinaSJ-1789
251
Reputation points
asked 2024-06-14T14:27:48.46+00:00
SujinaSJ-1789
251
Reputation points
0 answers
Issue with Batch Insertion using PreparedStatement in SQL Server
Hi, We are experiencing an issue while executing batch insertion using the preparedStatement.executeBatch() method in our Scala code. The problem is that it is inserting object references instead of actual values for VARCHAR columns. Below are the…
asked 2024-06-07T08:03:58.87+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(22.400000000000002, 7.000000000000001%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Anjali Garg
5
Reputation points
edited the question 2024-06-07T08:15:13.6533333+00:00
Anjali Garg
5
Reputation points
0 answers
How can I make sure these folders in sql don't appear every time I save another sql file
Screenshot 2024-06-05 094236.png After downloading sql server 2022, every time I save the file, additional folders '$MyDocuments$, Visual Studio 2017, Visual Studio 2017Templates' appear. Previously, for the SQL Server 2019 version, when pressing save,…
asked 2024-06-05T02:49:08.49+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, 19%, 32%)' 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)
Dukanhh
40
Reputation points
edited the question 2024-06-06T06:14:26.6+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,471
Reputation points Microsoft Vendor
0 answers
Facing slowness in SSRS report rendering with custom security implementation to support OIDC
Our application uses SSRS reports with embedded XML Data source. Reports are having multiple sub reports and sub reports are added dynamically based on data. Reports are rendering correctly with Windows Authentication. We have implemented SSRS Custom…
asked 2024-06-05T04:34:43.5733333+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(38.4, 53%, 13%)' 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)
TPP
0
Reputation points
edited the question 2024-06-05T06:02:34.64+00:00
ZoeHui-MSFT
34,756
Reputation points
0 answers
How to fix Could not load file or assembly 'Ionic.Zip, Version=1.9.1.8, Culture=neutral, PublicKeyToken=edbe51ad942a3f5c' or one of its dependencies erro
I am opening SSIS 2008 package on new Microsoft windows server 2019 datacenter ,for opening i am using sql server datatools 2019(VS2019) I added all the references of external DLL's but still getting System.IO.FileNotFoundException: Could not load file…
asked 2024-06-03T09:44:43.4466667+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(300.8, 25%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERT%3C/text%3E%3C/svg%3E)
Rohit Tandon
0
Reputation points
edited the question 2024-06-04T01:30:50.2466667+00:00
Anna Xiu-MSFT
27,471
Reputation points Microsoft Vendor
0 answers
When using AutoML for training a Win32Exception arises indicating that the wait operation timed out after 30 seconds
CPU: i7-12800h (14 cores, Total Threads: 20) RAM: 32 GB SSD: Samsung 980 Pro, 2 TB Windows Server 2019 Datacenter Evaluation NET Framework: 4.8 Microsoft.ML: 3.0.1 Microsoft.ML.AutoML: 0.21.1 Issue: When I start to train a model using AutoML, I get…
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,153 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,537 questions
.NET Machine learning
.NET Machine learning
.NET: Microsoft Technologies based on the .NET software framework.Machine learning: A type of artificial intelligence focused on enabling computers to use observed data to evolve new behaviors that have not been explicitly programmed.
153 questions
asked 2024-06-03T18:31:48.42+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, 16%, 32%)' 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)
Andreas ss
726
Reputation points
asked 2024-06-03T18:31:48.42+00:00
Andreas ss
726
Reputation points
0 answers
Path to Microsoft ODBC SSL Driver loaded libraries
How do configure dynamic loading of OpenSSL libraries for use MS ODBC? The Microsoft ODBC Driver for SQL Server on Linux version 17 dynamically loads the latest version of libssl based on its availability on the system. Our software is linked custom…
asked 2024-05-28T17:09:47.63+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, 38%, 16%)' 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)
Denis Kupavtsev
0
Reputation points
asked 2024-05-28T17:09:47.63+00:00
Denis Kupavtsev
0
Reputation points
0 answers
dacpac project .sqlproj creation. errors with multiple schemas
i have SQL Server database, with objects defined under two schemas, Schema 1 - dbo. Schema 2 - pr. Tables - dbo.person, dbo.orders, pr.person , pr.orders, pr.sales SP= dbo.getpersons, dbo.getdata, pr. salesinfo. when imported the data into .sqlproj…
asked 2024-05-17T15:26:35.8766667+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(240, 7.000000000000001%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERJ%3C/text%3E%3C/svg%3E)
Ramanjaneyulu Jerugula
0
Reputation points
edited the question 2024-05-20T01:28:38.8166667+00:00
Anna Xiu-MSFT
27,471
Reputation points Microsoft Vendor
0 answers
Modelos tabulares no liberan memoria
Buenos dias, paso a consultar por un problema. Tengo varios modelos tabulares, y cada vez que proceso alguna partición, la memoria de mi servidor llega a 85/90%. Una vez terminado el procesamiento, la memoria queda en esos niveles, por lo que si quiero…
asked 2024-05-17T11:56:15.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(256, 52%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERL%3C/text%3E%3C/svg%3E)
Roberto Lavisse
0
Reputation points
asked 2024-05-17T11:56:15.51+00:00
Roberto Lavisse
0
Reputation points
0 answers
Unable to start Microsoft SQL Server Migration Assistant for Access
I have installed SQL Server Migration Assistant for Access, but it will not start up. When I launch the program, it displays the splash screen and as it is displaying the message "Configuring Telemetry...", the program throws an exception. How…
asked 2024-04-24T04:58:52.4633333+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(150.4, 42%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAO%3C/text%3E%3C/svg%3E)
Alister Oram
0
Reputation points
asked 2024-04-24T04:58:52.4633333+00:00
Alister Oram
0
Reputation points
0 answers
Security Update for SQL Server 2019 RTM GDR (KB5035434) failed
Security Update for SQL Server 2019 RTM GDR (KB5035434) failed
asked 2024-04-21T23:27:28.2766667+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, 45%, 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)
Roger Bergeron
10
Reputation points
edited the question 2024-04-22T06:03:13.3566667+00:00
SadiqhAhmed-MSFT
40,016
Reputation points Microsoft Employee