SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,752 questions
1 answer
Is there any way to connect Hadoop to SSMS other than ODBC Driver.
We have jobs in SSMS. We are experiencing ODBC Error constantly when the job fails. but we could see other job which are running with same ODBC Driver its succeeding. To avoid this issue, we want to know is there any other way that we can connect Hadoop…
SQL Server | Other
asked 2024-05-03T13:12:37.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(73.60000000000001, 91%, 17%)' 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)
KANCHI BIANCA (CRGL-THIRDPARTY.COM)
5
Reputation points
edited a comment 2024-05-09T09:34:37.63+00:00
MikeyQiaoMSFT-0444
3,310
Reputation points
1 answer
How to accurately sequence Change Data Capture data?
We are using the Sql Server Change Data Capture feature to allow us to process data into our data warehouse which is working very well however, I have a quick question with regards to sequencing the data as I've read conflicting documents. We are…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,752 questions
asked 2023-07-11T13:26:10.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(195.2, 90%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
Andrew HB
361
Reputation points
commented 2024-05-09T05:03:31.83+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, 32%, 36%)' 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)
Oleg AtUbuntu
0
Reputation points
2 answers
How to share a report in SQL Server Reporting Services
I need to create a link to share a report that I created in SQL Server Reporting Services with other users. What is the best way to do this?
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,163 questions
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,752 questions
asked 2024-05-08T15:58:59.96+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(131.20000000000002, 2%, 22%)' 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)
Susan Moore
0
Reputation points
answered 2024-05-09T02:03:38.2433333+00:00
ZoeHui-MSFT
41,551
Reputation points
0 answers
User Managed identity with failover group with servers in different regions
while using user managed identity with azure sql , the connection string or token acquired using DefaultAzureCredential is dependent on the clientID of user managed identity. for the scenario when there is a sql failover switch i.e due to outage in one…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,890 questions
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,752 questions
asked 2024-05-07T19:44:02.75+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, 34%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKK%3C/text%3E%3C/svg%3E)
KAMALPREET KAUR
1
Reputation point Microsoft Employee
commented 2024-05-08T23:11:15.5166667+00:00
KAMALPREET KAUR
1
Reputation point Microsoft Employee
2 answers
One of the answers was accepted by the question author.
How can I resolve the "could not find server" error when using execute(@sql) at [linked_server] with a stored procedure?
I have created a stored procedure in SQL Server to execute a PL/SQL script to a linked Oracle server using either sp_executesql or execute(@sql). The former method works while the latter generates a "cannot find linked server" or…
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
286 questions
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,752 questions
asked 2024-05-08T15:59:54.14+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, 96%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETD%3C/text%3E%3C/svg%3E)
Timothy Dooling
25
Reputation points
commented 2024-05-08T23:10:31.9133333+00:00
Timothy Dooling
25
Reputation points
4 answers
Install only SQL SERVER 2022 integration services on host
Hi, during the SQL SERVER 2022 installation process, I selected only the Integration Services and the master-out. With my surprise the process not required installation of the SQL SERVER engine. At the end, as I suspected, it also installed a SQL…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,752 questions
asked 2024-05-08T10:36:48.9+00:00
Alen Cappelletti
1,047
Reputation points
commented 2024-05-08T22:23:29.3133333+00:00
Alen Cappelletti
1,047
Reputation points
2 answers
When I apply the latest patches cu in the SQL server 2022 version. It uses high memory. What is the reason? It will happen sometimes or regular
When I apply the latest patches cu in the SQL server 2022 version. It is using high memory. What is the reason? It will happen sometimes or regular.
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,752 questions
asked 2024-05-08T02:53:41.3533333+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, 73%, 29%)' 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)
Anandhswarupp
205
Reputation points
commented 2024-05-08T21:23:11.54+00:00
Erland Sommarskog
134.7K
Reputation points MVP
Volunteer Moderator
0 answers
When using execute(@sql) at [linked_server] I get "Could not find server" error
I have written the following stored procedure to execute a PL/SQL script to a linked Oracle server: ALTER PROCEDURE [dbo].[Oracle_s] ( @sql varchar(4000) ) AS BEGIN declare @result bit = 0; set nocount on; declare @temp nvarchar(4000) = 'SELECT *…
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
286 questions
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,752 questions
asked 2024-05-08T15:24:55.69+00:00
Timothy Dooling
25
Reputation points
commented 2024-05-08T21:14:12.93+00:00
Erland Sommarskog
134.7K
Reputation points MVP
Volunteer Moderator
2 answers
One of the answers was accepted by the question author.
SQLEXPRADV 2022
Does the sql express 2022 still have a separate SQLEXPRADV download? Im trying to download Express with Advanced Services and although the download page for express 2022 lists Express with Advanced Services (SQLEXPRADV). There is no option to select…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,752 questions
asked 2024-05-08T17:25:34.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(243.2, 72%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Chris Boyce
25
Reputation points
edited an answer 2024-05-08T19:07:51.4533333+00:00
Olaf Helper
47,621
Reputation points
1 answer
One of the answers was accepted by the question author.
¿Existe una url oficial donde me digan que tipo de licencia de SQL server necesito para replicar 5 bases de sucursales a una base centralizada?
podrían darme información oficial de favor para poder utilizar cualquier tipo de replicación https://learn.microsoft.com/es-es/sql/relational-databases/replication/types-of-replication?view=sql-server-ver16 y cual licencia debo comprar para pode…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,752 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(214.4, 62%, 30%)' 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)
1 answer
How do I transfer an on-premises license from one corporate user to another?
I need to transfer an on-premise license, but I'm having trouble finding materials explaining the step-by-step process, as well as which instrument should be used for the transfer. Can You help me?
Windows for business | Windows Client for IT Pros | User experience | Other
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,752 questions
asked 2024-05-03T12:29:56.53+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(233.6, 84%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETC%3C/text%3E%3C/svg%3E)
Takeo Contao Abe TERNIUM BR
0
Reputation points
answered 2024-05-08T13:17:30.4366667+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, 9%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWL%3C/text%3E%3C/svg%3E)
Wesley Li
11,855
Reputation points
2 answers
One of the answers was accepted by the question author.
SSMS 20.1 Unable to see SSIS Execution Properties
Ever since I installed SSMS 20.1, I've been unable to look up the properties in SSIS jobs. I'm aware that 20.1 has changed the way connections are made but my connection is set up with "Trust server certificate" and multiple menus error…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,796 questions
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,752 questions
asked 2024-05-07T12:59:51.8066667+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, 63%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EML%3C/text%3E%3C/svg%3E)
Michel Lalancette
20
Reputation points
commented 2024-05-08T12:12:19.7933333+00:00
Michel Lalancette
20
Reputation points
0 answers
Ununable to install sql server (setup.exe) Exit code (Decimal): -2147467259 Error description: The service did not respond to the start or control request in a timely fashion.
I'm trying to download SQL express through the installation process it gives me an error Oops... Unable to install sql server (setup.exe) Exit code (Decimal) -2147467259E Error description: The service did not respond to the start or control request in…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,752 questions
asked 2024-04-30T15:39:20.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(134.4, 2%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
moris shehady
0
Reputation points
commented 2024-05-07T21:15:27.4233333+00:00
Erland Sommarskog
134.7K
Reputation points MVP
Volunteer Moderator
1 answer
How to fix NT AUTHORITY\ANONYMOUS LOGON login failure during MS SQL Server installation
Hi - I'm trying to install MS SQL Server on Microsoft Windows Server 2022 Standard 10.0.20348 Build 20348. I've tried installing both MS SQL Server 2019 and 2022. The installation fails with: Detailed results: Feature: Database…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,752 questions
asked 2024-05-02T14:35:00.5566667+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, 8%, 22%)' 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)
Anonymous
commented 2024-05-07T13:19:06.6166667+00:00
Anonymous
2 answers
The transaction log for database is full due to 'REPLICATION'
Hi! I have a SQL 2019 database that is a member of 3 node always on availability group. It is also the subscriber being populated from a DB2 database. The log keeps filling up and I am unable to shrink or backup.. I get the message: The transaction log…
Developer technologies | Transact-SQL
Developer technologies | Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,717 questions
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,752 questions
asked 2022-04-25T08:33:47.077+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, 99%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZO%3C/text%3E%3C/svg%3E)
zoe Ohara
286
Reputation points
commented 2024-05-07T09:12:45.76+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(48, 74%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Rishi Sethi
0
Reputation points
0 answers
Key store providers cannot be set more than once(Always Encrypted with JDBC and Java 8)
We are trying to use SQL Always Encrypted feature in our Java Web Application. Java 8 is the JRE and uses mssql-jdbc-9.2.1.jre8.jar as the jdbc driver. Azure-Key-vault as the column master key store provider Our application uses below code to…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,752 questions
asked 2021-11-09T04:53:17.773+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, 3%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Subin Sankaran
1
Reputation point
commented 2024-05-07T09:07:01.79+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(32, 44%, 13%)' 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)
Manjunatha Bhimanna (Aspiresys Consultant)
0
Reputation points
2 answers
Named Pipes Provider: Could not open a connection to SQL Server
Hi, Named Pipes Provider: Could not open a connection to SQL Server error (53) from public facing Server to Local SQL Server but Local to DMC Server possible Please any one can you advice to me Kind Regards R.Raja
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,752 questions
asked 2024-05-02T05:30:16.5+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, 84%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERR%3C/text%3E%3C/svg%3E)
Raja Raju
0
Reputation points
commented 2024-05-06T20:43:46.97+00:00
Erland Sommarskog
134.7K
Reputation points MVP
Volunteer Moderator
1 answer
Scripting out 'Create Merge Replication' does not include 'processing_order'
We use Merge Replication and have defined a specific 'processing_order' for the Articles in the Publication. The Articles include tables, functions and stored procedures. When we want to setup or refresh a test environment, we will script out the…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,752 questions
asked 2024-05-03T03:20:20.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(60.8, 9%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGY%3C/text%3E%3C/svg%3E)
Greg Youdale
5
Reputation points
commented 2024-05-07T06:16:19.72+00:00
Greg Youdale
5
Reputation points
2 answers
One of the answers was accepted by the question author.
Integration service on dedicated SQL instance
Based on an assessment I did on a client's server, I have to move all the integration services to a dedicated machine. We decided to separate ETL and data on two machines. My question is: having a dedicated instance, how do I manage the memory CAP on…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,752 questions
asked 2024-05-06T09:26:30.6333333+00:00
Alen Cappelletti
1,047
Reputation points
accepted 2024-05-07T07:29:42.83+00:00
Alen Cappelletti
1,047
Reputation points
2 answers
Text delimiter file
Hi, I have two tables: one for headers with 9 fields and another for lines with 6 fields. Both header and lines are highlited in yellow. I need to combine both the headers and lines using a UNION operation to display the result below. From the line…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,796 questions
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
286 questions
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,752 questions
asked 2024-05-06T14:48:13.48+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(182.40000000000003, 69%, 27%)' 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)
Vicki
46
Reputation points
answered 2024-05-07T02:18:28.6533333+00:00
LiHongMSFT-4306
31,621
Reputation points