SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,959 questions
1 answer
Migrating varbinary data from onprem SQL table to Azure blob storage.
Hi, I need to move the varbinary data in one of my on Prem SQL data table column Column(binary_data) which needs to be uploaded to azure blob storage. We have 2 million rows in the table and every row should create one file in the blob storage for…
asked 2024-10-21T14:22:23.4666667+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, 30%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Vijay Sawant
0
Reputation points
edited the question 2024-11-05T04:35:06+00:00
Sumarigo-MSFT
46,441
Reputation points Microsoft Employee
1 answer
Migrating varbinary data from onprem SQL table to Azure blob storage.
Hi, I need to move the varbinary data in one of my on Prem SQL data table column Column(binary_data) which needs to be uploaded to azure blob storage. We have 2 million rows in the table and every row should create one file in the blob storage for…
asked 2024-10-21T14:22:23.4666667+00:00
Vijay Sawant
0
Reputation points
edited the question 2024-11-05T04:35:06+00:00
Sumarigo-MSFT
46,441
Reputation points Microsoft Employee
0 answers
Autoloader in Synapse
I want to load data incrementally using Azure Synapse Analytics Notebook(dedicated spark pool) there is an option on databricks to load data incrementally which is autoloader so my question was can we use this option in Azure Synapse Analytics…
asked 2024-01-24T11:33:32.82+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, 69%, 15%)' 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)
Aditya Singh
160
Reputation points
edited the question 2024-11-05T03:52:58.6933333+00:00
Sumarigo-MSFT
46,441
Reputation points Microsoft Employee
1 answer
Error installing SQL SERVER EXPRESS on Windows 11
I am trying to install SQL Server Express 2019 on my new Windows 11 laptop. I have tried searching errors, but am not experienced enough to link solutions to my specific issue. Any help appreciated!
asked 2024-11-04T22:33:49.0133333+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, 59%, 35%)' 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)
Anthony Gribben-Lisle
0
Reputation points
answered 2024-11-05T03:15:00.3+00:00
ZoeHui-MSFT
37,376
Reputation points
1 answer
Unable to Install Microsoft Sql Server 2022 and 2019
Here's the Error LogSQLServer_ERRORLOG_2024-11-04T11.10.52.txt
asked 2024-11-04T20:27:40.2933333+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(102.4, 73%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAT%3C/text%3E%3C/svg%3E)
Adam Teth
0
Reputation points
answered 2024-11-05T03:06:37.4066667+00:00
ZoeHui-MSFT
37,376
Reputation points
0 answers
Problems with passing Binary as a table-valued parameter
I'm using table-valued parameters to pass binary values. I used SQLBindParameter and passed the values as SQL_C_BINARY, SQL_BINARY, BinarySize, etc. as the arguments, but when I run SQLExecute, I get an error or the result is different from what I…
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,959 questions
C++
C++
A high-level, general-purpose programming language, created as an extension of the C programming language, that has object-oriented, generic, and functional features in addition to facilities for low-level memory manipulation.
3,758 questions
![](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, 9%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
1 answer
Can't run query if defining temp table
I have the following T-SQL: alter procedure myProc_sp AS BEGIN create table #myTable ( retireeId varchar(12) ) select getDate() return END With the 'create table' statement in there, it returns zero rows. If I comment out the 'create table' it…
asked 2024-11-04T17:42:24.9766667+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, 54%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOA%3C/text%3E%3C/svg%3E)
OHPRS Admin
211
Reputation points
commented 2024-11-05T01:57:23.27+00:00
LiHongMSFT-4306
27,961
Reputation points
0 answers
SQL Server Database Engine Services Instance Features
I'm having trouble reinstalling SQL Server Express 2022 on my computer. My Windows is up to date, and my system meets the minimum requirements. I had SQL Server Express installed before, but since reformatting my system, I’ve been unable to install it…
asked 2024-11-04T22:11:11.4866667+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, 60%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFL%3C/text%3E%3C/svg%3E)
francisco lopes
0
Reputation points
commented 2024-11-05T01:32:50.6+00:00
LiHongMSFT-4306
27,961
Reputation points
3 answers
Generate auto generated string while importing data using SSIS
Hi Team, Could you please help me on bellow issue. Am pushing data from snowflake to SQL server using SSIS and while loading need to generate incremental string in destination. For example: Source: Destination: Thanks in advance.
asked 2024-11-04T16:18:28.0766667+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(201.6, 0%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBN%3C/text%3E%3C/svg%3E)
Bala Narasimha Challa
466
Reputation points
answered 2024-11-05T01:29:09.0633333+00:00
ZoeHui-MSFT
37,376
Reputation points
0 answers
external component has thrown an exception. (system.data)
Server Management Studio Import Wizard external component has thrown an exception. (system.data)
asked 2024-11-04T16:55:26.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(108.80000000000001, 16%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHE%3C/text%3E%3C/svg%3E)
Harald Eichberger-Czerny
0
Reputation points
commented 2024-11-05T01:25:22.8466667+00:00
LiHongMSFT-4306
27,961
Reputation points
1 answer
Please provide windows powershell commands to import a database backup file which is on azure blob storage account to my azure SQL vm in which sql image is installed
we have a windows sql vm where we have a preinstalled sql windows 2022 image in it. Now there is a database backup file that is stored in azure blob storage now we want to import that file into this azure sql vm can we get any powershell commands for…
asked 2024-11-04T11:56:59.7933333+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(51.2, 82%, 14%)' 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)
Aravapalli Ojeswi
0
Reputation points
edited the question 2024-11-05T00:53:13.9633333+00:00
LiHongMSFT-4306
27,961
Reputation points
3 answers
SQL Server 2022 won't install
Overall summary: Final result: Failed: see details below Exit code (Decimal): -2068119551 Exit facility code: 1211 Exit error code: 1 Exit message: Cannot find registry key…
asked 2023-03-08T13:29:55.8733333+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, 49%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZA%3C/text%3E%3C/svg%3E)
Zuhayr Arif Zakaria
5
Reputation points
commented 2024-11-04T22:17:54.1266667+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, 59%, 16%)' 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)
saul martinez
0
Reputation points
0 answers
In the UK South region, we face SQL Server login issues. The ensureCreated method fails with “Login failed for user ‘myUsername’.”
In the UK South region, we are experiencing issues with the SQL Server login. Although we are using the correct username and password, the login fails when attempting to call the method ensureCreated from Entity Framework, we encounter the error:…
asked 2024-11-04T15:17:49.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(300.8, 23%, 39%)' 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)
nikithakoshy
80
Reputation points
commented 2024-11-04T20:19:17.8166667+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, 60%, 34%)' 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)
Mahesh Kurva
725
Reputation points Microsoft Vendor
1 answer
Issue while connecting on-prem SQL server from Logic App standard workflow
Hello community members, I am trying to connect to on prem SQL server via Logic apps(standard) using on-prem data Gateway. I am getting below error while trying to connect. Failed to retrieve dynamic inputs. Error details: 'Error code: 'BadRequest',…
asked 2024-11-04T15:09:03.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(217.60000000000002, 19%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDT%3C/text%3E%3C/svg%3E)
Dhananjay Tripathi
0
Reputation points
answered 2024-11-04T18:35:47.32+00:00
LeelaRajeshSayana-MSFT
15,886
Reputation points Microsoft Employee
0 answers
SSMS 20.0 doesn't allow to add publisher on Replication Monitor
I have installed SSMS 20.0 on my Windows 11 machine. I opened Replication Monitor and there is no option for me to add publisher to Replication Monitor. Any help greatly appreciated.
asked 2024-10-28T22:18:11.3+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, 64%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENB%3C/text%3E%3C/svg%3E)
Nama Budidi
21
Reputation points
commented 2024-11-04T17:55:00.7666667+00:00
Nama Budidi
21
Reputation points
0 answers
How to migrate large Sybase database using SSMA for Sybase
We are on Sybase/SAP ASE database of various sizes the larges one contains about 1TB of data. We are testing the migration it to on-premise MS SQL Server 2022 Linux, using SSMA for Sybase. Our concern is to move the full data during the downtime which…
asked 2024-11-04T17:31:34.44+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, 40%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETK%3C/text%3E%3C/svg%3E)
Tahir Khalil
41
Reputation points
asked 2024-11-04T17:31:34.44+00:00
Tahir Khalil
41
Reputation points
0 answers
How to migrate large Sybase database using SSMA for Sybase
We are on Sybase/SAP ASE database of various sizes the larges one contains about 1TB of data. We are testing the migration it to on-premise MS SQL Server 2022 Linux, using SSMA for Sybase. Our concern is to move the full data during the downtime which…
asked 2024-11-04T17:31:34.44+00:00
Tahir Khalil
41
Reputation points
asked 2024-11-04T17:31:34.44+00:00
Tahir Khalil
41
Reputation points
1 answer
SSMA for Sybase truncating image data type to 32768
Hi, I am using SSMA for Sybase to migrate Sybase ASE 16 database to MS SQL Server 2022 on Linux. A table with image type column is migrated but the data in this column limited to 32768. I believe if this data migration program is using bcp - it might be…
asked 2024-10-22T21:05:20.3966667+00:00
Tahir Khalil
41
Reputation points
commented 2024-11-04T17:21:16.84+00:00
Tahir Khalil
41
Reputation points
1 answer
SSMA for Sybase truncating image data type to 32768
Hi, I am using SSMA for Sybase to migrate Sybase ASE 16 database to MS SQL Server 2022 on Linux. A table with image type column is migrated but the data in this column limited to 32768. I believe if this data migration program is using bcp - it might be…
asked 2024-10-22T21:05:20.3966667+00:00
Tahir Khalil
41
Reputation points
commented 2024-11-04T17:21:16.84+00:00
Tahir Khalil
41
Reputation points
1 answer
The certificate chain was issued by an authority that is not trusted.
Hello. I've got an existing server a few years old that we've never had any issues connecting to. However, all of a sudden when trying to create new connections we are getting the message "The certificate chain was issued by an authority that is…
![](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, 26%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)