SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,851 questions
1 answer
SQL Server Maintenance Plan: Cleanup Task
Hello! Some time ago I noticed that my two maintenance plans were working incorrectly: the cleanup tasks that must have been deleting files older then 2 weeks had not been really deleting anything and my oldest files were ~29.02.2024. The reason was that…
asked 2024-05-17T09:41:25.65+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, 91%, 30%)' 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)
Hram Admin
0
Reputation points
answered 2024-05-17T18:01:54.44+00:00
Olaf Helper
41,006
Reputation points
1 answer
Issue with Excel Destination character size in SSIS
I am trying to export data from a database table in SQL server 19.1 version to a Excel file using SSIS excel destination task. One of the fields 'External Notes' coming from SQL database is VARCHAR(5000). I can export everything to excel but the…
asked 2024-05-17T11:41:58.3833333+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(272, 47%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
Dhanvi Bansal
0
Reputation points
answered 2024-05-17T17:56:33.1666667+00:00
Olaf Helper
41,006
Reputation points
4 answers
SSIS Error: The AcquireConnection method call to the connection manager Source failed with error code 0xC0014009.
Hello, We have a Job in MS SQL Server Management Studio. This job runs several Visual Studio SSIS packages. When we launch the job it fails at step one. Step one is to retrieve data from a AS400 DB and place it in some ODS tables within our…
asked 2021-06-17T10:50:35.957+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, 80%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERI%3C/text%3E%3C/svg%3E)
Romeo Isfan
11
Reputation points
answered 2024-05-17T16:29:25.6866667+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, 53%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELC%3C/text%3E%3C/svg%3E)
Larry Carrethers
0
Reputation points
6 answers
SQL SERVER 2022 - certificate error when creating a job for integration services
In a test environment with SQL Server 2022 Developer Edition, I am trying to create a job to run an SSIS package. These same packages have been successfully tested in SQL 2019. When trying to create the job, configuring it as follows: General / Owner :…
asked 2024-04-10T03:35:21.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(278.4, 98%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Marcio Matos
25
Reputation points
answered 2024-05-17T16:24:25.9966667+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(19.2, 78%, 11%)' 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)
Carl BRUBAKER
0
Reputation points
2 answers
Best practice on performing maintenance on a 2 node SQL Server Cluster with no witness.
Hello, We have a two-node SQL Server Cluster with no witness. Each month we patch the secondary server, then perform a failover and then patch the new secondary server. We do nothing special to tell the cluster that a node is going offline for patching.…
asked 2024-05-17T11:16:51.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(150.4, 62%, 24%)' 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)
Theo
0
Reputation points
answered 2024-05-17T15:59:17.1366667+00:00
Alex Bykovskyi
1,831
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…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,669 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.
12,851 questions
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
asked 2024-05-17T15:26:35.8766667+00:00
Ramanjaneyulu Jerugula
0
Reputation points
1 answer
AKS deployed application to access on-prem server
Hi, I want to connect to on-prem sql server from a .net application which is deployed in AKS. We already have Azure relay/hybrid connection setup for the same, but that requires azure app service. I am looking for options to connect from AKS deployed…
asked 2024-05-16T12:53:21.2833333+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(19.2, 54%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Santhi Dhanuskodi
145
Reputation points
edited a comment 2024-05-17T15:16:58.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(211.20000000000002, 61%, 30%)' 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)
Bruce (SqlWork.com)
57,481
Reputation points
1 answer
SSIS - Flat File Destination Fixed Width Columns Appear to be Ragged
I am trying to create a flat file export, the spec is fixed width column, no headers or delimiters. There are 16 columns, the total width of all the columns combined is 624 characters. i have attempted two methodologies, both yield the same result where…
![](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(115.19999999999999, 94%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKW%3C/text%3E%3C/svg%3E)
0 answers
Reclaiming free space from TempDB in azure sql managed instance
the TempDB on my azure sql managed has grown to 350 GB but 99% of that space shows as unused. i tried to shrink the database and individual files but the server is not freeing up the space. the space is still reserved for tempdb. Microsoft docs is…
asked 2024-05-17T12:34:07.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(300.8, 1%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH6%3C/text%3E%3C/svg%3E)
HusainIbrahem-6130
0
Reputation points
edited the question 2024-05-17T14:18:21.7566667+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(124.80000000000001, 64%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EON%3C/text%3E%3C/svg%3E)
OMMI NAVEEN KUMAR
195
Reputation points Microsoft Vendor
0 answers
how to fix "Event ID 1309 from source ASP.NET 4.0.30319.0 cannot be found" Could not find file 'C:\Windows\TEMP\fsd3ypse.dll'.
Event code: 3005 Event message: An unhandled exception has occurred. Event time: 4/29/2024 10:23:20 AM Event time (UTC): 4/29/2024 5:23:20 PM Event ID: 9b963c660c6142f28d1ee5d6ff0786a3 Event sequence: 61229 Event occurrence: 6 Event detail code: 0…
Microsoft Edge
Microsoft Edge
A Microsoft cross-platform web browser that provides privacy, learning, and accessibility tools.
2,161 questions
Windows Server 2019
Windows Server 2019
A Microsoft server operating system that supports enterprise-level management updated to data storage.
3,491 questions
Internet Information Services
Internet Information Services
Microsoft web server software.
1,593 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.
12,851 questions
asked 2024-05-17T09:58:38.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(22.400000000000002, 75%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Sakthi Ganesh S
0
Reputation points
commented 2024-05-17T13:14:40.05+00:00
JasonPan - MSFT
4,386
Reputation points Microsoft Vendor
3 answers
Transactional Replication on a SQL Managed instance as a subscriber with pull subscription
We are doing a transactional Replication to a SQL Managed instance (subscriber) with pull subscription from On-Prem(Publisher/Distributor) We are seeing uninitialized subscription on the replication monitor. How can we troubleshoot this
![](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(124.80000000000001, 84%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENV%3C/text%3E%3C/svg%3E)
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
How to move/change Azure SQL Server from one region to another?
We have one Azure sql server hosted in the East US location in Azure and now we want to change its location to some other location. How can I do this? Appreciate it if you give a resolution for this.
asked 2024-05-17T11:33:28.2066667+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(140.8, 76%, 23%)' 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)
RAJ KUMAR REDDY AVULA
0
Reputation points
asked 2024-05-17T11:33:28.2066667+00:00
RAJ KUMAR REDDY AVULA
0
Reputation points
1 answer
客户端与服务端sql server交互问题
问题背景： 一款系统产品的部署测试，SQL Server版本SQLServer2016SP2-FullSlipstream-x64-CHS（一开始为2017有问题，后降到2016仍有问题），服务器系统Windows Server…
asked 2024-05-17T06:18:32.2966667+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, 94%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGG%3C/text%3E%3C/svg%3E)
GUGU GU
0
Reputation points
edited an answer 2024-05-17T09:58:14.6466667+00:00
MikeyQiao-MSFT
575
Reputation points Microsoft Vendor
2 answers
SQL Server 2022 express download problem unable to install SQL Server. Exit code(Decimal): -2061893606
I'm trying to download SQL Server 2022 Express, but it's giving the following error. I checked the log and click the SystemConfigurationCheck_Report I received the warning shown in the image above. Is the download error caused by this? I had already…
asked 2024-05-09T12:23:12.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(259.20000000000005, 4%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Mehmed Aras
0
Reputation points
commented 2024-05-17T09:08:32.44+00:00
LucyChenMSFT-4874
1,280
Reputation points
2 answers
One of the answers was accepted by the question author.
Create a SQL Server JOB using SSMS 20.X for a .dtsx package from the ssisdb server
I installed SSMS 20.X and understood the problems connecting to the instance: I am successfully connected. Now I would like to schedule a JOB with an integration services step (which I have done hundreds of times in the past)... but with SSMS versions…
asked 2024-05-16T12:42:16.2333333+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, 60%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAC%3C/text%3E%3C/svg%3E)
Alen Cappelletti
951
Reputation points
accepted 2024-05-17T09:04:54.55+00:00
Alen Cappelletti
951
Reputation points
1 answer
unable to connect another data base in same server which is azure sql - through ssms
Issue description: Msg 40515, Level 15, State 1, Line 66 Reference to database and/or server name in 'sriniazpracticedbserver.database.windows.net.TARGET.dbo.data_trg' is not supported in this version of SQL Server. Completion time:…
asked 2024-05-17T05:49:15.5066667+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, 59%, 37%)' 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)
Srinivas Mantri
0
Reputation points
answered 2024-05-17T09:03:21.6+00:00
CosmogHong-MSFT
23,556
Reputation points Microsoft Vendor
0 answers
How To send mail with attachment from SQL MI
Hi Team, I am using msdb.dbo.sp_send_dbmail to send mail from sql mi. I need to send this mail with attachment. Since SQL MI does not support file attachment i am looking for the alternatives. I have one https service like https://test/getfile service…
asked 2024-05-17T08:52:23.3666667+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(265.6, 93%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERY%3C/text%3E%3C/svg%3E)
Radhakrishnan, Yadu Krishnan (Allianz Technology)
0
Reputation points
edited the question 2024-05-17T08:55:07.1433333+00:00
Radhakrishnan, Yadu Krishnan (Allianz Technology)
0
Reputation points
1 answer
How to fix issue in prepapred statement on jdbc driver 12.6.1 jre11
Recently we have upgrade the SQL JDBC driver from version 4 to version 12.6.2 jre11 as we upgraded to 2022 SQL server. After changing the driver we are facing issue in prepared statement. The same code with 12.6.2 jre8 and java8 returning results . But…
asked 2024-05-10T13:49:21.6766667+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, 16%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDM%3C/text%3E%3C/svg%3E)
Dhamodharan M
0
Reputation points
commented 2024-05-17T07:50:19.5+00:00
MikeyQiao-MSFT
575
Reputation points Microsoft Vendor
4 answers
Enterprise Report Server not showing Data Driven Subscriptions
We have updgraded from Standard to Enterprise reporting services. We were expecting to have the option to create data-driven subscriptions but the option is not available. All the articles found during our web search say 'Data-driven subscriptions' will…
asked 2024-04-29T21:26:46.1566667+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(281.6, 72%, 37%)' 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)
Linda
1
Reputation point
answered 2024-05-17T07:20:47.92+00:00
ZoeHui-MSFT
33,386
Reputation points