Recent Discussions
Do input tag values keep updating after SP execution begins?
In my facility we use PLC's to trigger SQL Stored Procedures through a Kepware server. Most of these SP's are for data collection. If I set the execute bit to true, but then one of my data collection points changes value before the execution finishes, does the SP see that data change? Or is it just using the value as it was at time of execution start? Thanks for your help in advance
SQL 2025 Jobs
SQL Server 2022 16.0.4212.1 Installed in a windows server 2025 DC. SQLSERVERAGENT starts with NT Service\SQLSERVERAGENT I have some jobs that runs at the scheduled times. But one no. Failure: "Job failed. The job was invoked by Schedule 9 (06:00 xxxxx). The last step to execute was step 0 (no steps ran)." Job steps: exec SP_01 GO EXEC SP_02 But if I run it manually, it runs without problems. Can anyone help me? Thank you
SQL Server 2019 – Repeated Recovery Mode and Backup Failure After Server Shutdown
Hello, We are currently using SQL Server 2019 Standard Edition in our company. Recently, our server experienced a complete shutdown due to a lightning strike. After the incident, one of our databases entered Recovery Mode, and it took approximately one hour before it returned to normal operation. The issue is that this behavior repeats every time we restart SQL Server. In other words: Server restart → Database enters Recovery Mode → Returns to normal after about one hour. Additionally, we are unable to perform backups on this database. Based on the SQL Server error logs and Windows Event Viewer, it appears that the backup attempts fail because the database has not completed recovery at the time of execution. We would like to ask for guidance on the following points: Could this issue be related to physical damage or disk corruption? Is there a way to prevent the database from entering Recovery Mode, or at least speed up the recovery process? Besides running DBCC CHECKDB, are there any other diagnostics or recovery strategies we should consider? Additional Information: SQL Server 2019 Standard Edition (on-premises) The affected database is running on a single instance We attempted to copy only the MDF file to another server and recover the database, but this also failed Thank you in advance for your support.
SQL Server 2022 Express Install Issues
I am a non tech savvy student trying to install SQL Server 2022 Express for class and I am running into issues, looking for help. It gets all the way through the install process and gives me "Unable to install SQL Server (setup.exe) Exit code (Decimal): -2061893606Error description: Wait in the Database Engine recovery handle Failed. Check the SQL Server error log for potential causes" and C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log\20250903_162628 I have fully uninstalled anything related to SQL and reinstalled multiple times with no success. I reset windows, no luck. Any help would be appreciated.
SQL Server not supported Windows 11 Home Version
I bought a new computer that came with Windows 11 Home. I am unable to install SQL Server 22 on W11. I would like to install Windows 10 that does support SQL server but I will void my support warranty doing so. I suspect I can upgrade to Windows 11 Pro but I am not sure that OS supports SQL Server. Any thoughts or advice would be helpful.Availability Group failover issue
Hello, We ran into an issue recently that caused a three-node availability group to fail. We're running SQL Server 2019 (RTM-CU32-GDR) on Windows Server 2019 Standard (version 1809). We're trying to understand why the availability group wasn't able to start when the cluster automatically failed it over to another node. First, here is the state/configuration of the availability group just before the failure: Node A - primary replica; synchronization state = synchronized; availability mode = synchronous commit; failover mode = automatic Node B - secondary replica; synchronization state = synchronized; availability mode = synchronous commit; failover mode = automatic Node C - secondary replica; synchronization state = synchronized; availability mode = synchronous commit; failover mode = manual Here's the abbreviated summary of events: An I/O error occurred on node A. Specifically, it was a checksum mismatch when reading one of the tempdb files. This caused the availability group cluster resource to fail. The cluster tried unsuccessfully to restart the AG on node A so it failed over the AG to node B. The AG failed to come online on node B. The cluster failed back the AG to node A and left it in a failed state. We manually failed over the AG to node B a few minutes later and it was successful. When the cluster tried to automatically fail over the AG to node B, the only error we found that indicates why the AG couldn't start is: "SQL Server Availability Group <AG1>: [hadrag] ODBC Error: [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]The availability replica for availability group 'AG1' on this instance of SQL Server cannot become the primary replica. One or more databases are not synchronized or have not joined the availability group. If the availability replica uses the asynchronous-commit mode, consider performing a forced manual failover (with possible data loss). Otherwise, once all local secondary databases are joined and synchronized, you can perform a planned manual failover to this secondary replica (without data loss)." Since all nodes were in synchronous commit mode, the above error implies that the secondary databases on node B were either not joined or not synchronized. This is concerning and we're worried that auto-failover is not as reliable as we expected. Does anyone have any suggestions for how to ensure the secondary node is ready and able to become primary when the AG fails on the original primary node? Or any suggestions for settings/configuration to change? The only corrective action we have taken so far is to increase the "maximum failures in the specified period" from the default of 2 to 6 (per the recommendation https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/hadr-cluster-best-practices?view=azuresql&tabs=windows2012#relaxed-monitoring) and to decrease the failover period from the default of 6 hours to 2. Any suggestions or insights would be greatly appreciated.
SQL SERVER EXPRESS EDITION 2022 NOT INSTALLING ON MY SNAPDRAGON X PROCESSOR
Every time i try to install sql server on my laptop ASUS ASUS Vivobook S16 (2025) with Office 2024 + M365 Basic*, Metal Body*, Qualcomm Snapdragon X - (16 GB/512 GB SSD/Windows 11 Home) S3607QA-SH075WS Thin and Light Laptop (16 inch, Cool Silver, 1.74 Kg, With MS Office) I get this error: Error installing SQL Server Database Engine Services Shared Features There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor. Error code: 1722 Log file: C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log\20250811_013441\sql_engine_core_shared_Cpu64_1.log Attaching the error ss Let me know what should I doFail to OPENROWSET insert geometry data from parquet
Hi! I'm trying to insert geometry data (WKB) from a parquet file to a data base table. I manage to get it working for small geometries but it's failing for lager geometriers. Here is the code: INSERT db.s.t SELECT geometry::STGeomFromWKB(a.geom,1) FROM OPENROWSET ( BULK 'path_to.parquet', FORMAT = 'PARQUET', DATA_SOURCE = 's3_sorce' ) AS a The failure: String or binary data would be truncated while reading column of type 'VARBINARY(8000)'. Check ANSI_WARNINGS option.... Seems as if the geometry type is not recognized. Is there a way around this?How to resolve issue of custom Audit log table containing incorrect data?
We have created a parent table, child table & Audit log table in SQL Server database. For one parent record, there are multiple child records. When a child record in updated, a Stored Procedure is called in which a few fields of all the child records are updated that are associated with the parent record. We have 'for insert/for update' triggers created on the child table in SQL Server which inserts the new/updated child record into a custom Audit log table. The 'for update' trigger for the child table uses mapping based on the parent record id for inserted & deleted pseudo tables. This 'for update' trigger adds into Audit log table any changes done to the child record fields except the few fields that are updated using the Stored Procedure. We have noticed a pattern in the Audit log table which reoccurs again & again only in Production env. We are unable to reproduce this issue in Non-Production envs. After about 25 to 30 correct child records for several parent records are added in the Audit log table that the user had updated in the child table, several old child records for a parent record also get added into the Audit log table which were not updated in the child table by the user. Please let us know what is the root cause & resolution of this issue.Integration Services service "Computer Name" failed with error: "Class not registered"
Hi All, See below error when trying to login to intergration service. Does anyone know how to resolve? Connecting to the Integration Services service on the computer "Computer Name" failed with the following error: "Class not registered". This error can occur when you try to connect to a SQL Server 2005 Integration Services service from the current version of the SQL Server tools. Instead, add folders to the service configuration file to let the local Integration Services service manage packages on the SQL Server 2005 instance. RegardsNeed help with SQL error 26
Hi All, I need help with SQL server error 26, I have a desktop application that runs on Windows Server and the app could be open on some servers and not others, attached image is the error that I get and I confirmed there is no firewall block as I could ping the SQL server and also remote desktop into it, can anyone advise me on this, thanks.
To call a VBA script from a T-SQL procedure
I have the following (unusual) task: I need my T-SQL procedure to somehow call a VBA script. The VBA should copy all content of a certain sheet of an input Excel file into a certain sheet of an output Excel file. The physical full path of the input Excel file is available only in the T-SQL procedure. Therefore, the procedure should somehow pass the file path into the VBA script. How can I do that?
adding computed column to MS SQL
would like to check how to add a computed column with the following requirement Column value will be C-yyyyMMdd-0001 where date will be from the CreatedDate column in the same table. 0001 is an auto-incremental value based on when the record is inserted on the same day eg, the first record added on 23/08/2025, the computed column will be C-20250823-0001. As the table may already contain existing data, a SQL script may also be necessary to update this new column with the correct value.SQL Server 2017 – CLR was loaded in an unsupported manner (All SSIS jobs failed)
Hi, We are facing a critical issue in our SQL Server 2017 instance. When trying to use a built-in CLR function or running SSIS-related jobs, we are getting the below error: The Common Language Runtime (CLR) was loaded in an unsupported manner. This can occur if an extended stored procedure or OLE Automation object running in SQL Server calls into managed code before the CLR integration runtime host loads the CLR. You need to restart SQL Server to use CLR integration features. Steps tried so far: Restarted SQL Server service Restarted the entire Windows Server Verified .NET Framework version (4.7.03062 installed) Confirmed CLR integration is enabled (sp_configure 'clr enabled', 1) All SSIS jobs are failing due to this issue. Any suggestions, please?SQL server 2016 with Integration services on Ubuntu
Hi everyone, I need to setup SQL server 2016 on Ubuntu with Integration Services. Is it feasible to install SSIS with SQL server 2016 on Ubuntu for Prod use? If i go to Microsoft documentation,they only showing SQL 2017 and 2019 for Linux. Can anyone help with any related resources for clarification w.r.t SQL 2016? Thanks in advance PrakashChange SQL Login to AD service account for Link server
Hi Everyone, I tried to change account used to impersonate from SQL account to AD service account for link server however im getting below error. The AD service account has sys admin rights on the SQL servers. Access to the remote server is denied because no login-mapping exists. (Framework Microsoft SqlClient Data Provider) Any ideas how to resolve? RegardsAssistance with SQL Joins - or - using Nested/Subquery?
Relative noob to SSMS, however have had decent success in a few simple queries with 4-7 joins. In two separate queries i can capture two populations of data that apply to and link through a group of provider ID's. The two queries are as follows: 1. identify group of providers set to active status on or after a given approval date. 2. identify all plans and addresses linked to each provider Each of those function perfectly on their own, but i am struggling to pull the providers active approval date (Q1) (which is it's own column) into the output of Query 2, listing of all plans and addresses linked to that provider. In these scenarios it's important to note - A provider will have a single approval date, multiple addresses, and each address will be tied to 15-17 insurance plans - so a single to many to many relationship. Assignment_RTK is our systems key for 'Insurance Plan', Entity_K is key for which organization a provider is working for, and Provider_K is the provider key. Provider_K, Entity_K, and OriginalAppointmentDate all live in the EA (Entity Assignments) table. Plan keys in the form of Assignment_RTK live, somewhat confusingly in the EntityAssignment table as well, but adding either the provider approval date as a criteria to Query 2 will result in no returns (but also no errors), and adding the Plan Keys (Assignment_RTK) to the Approval date query will result in Null values in Assignment_RTK column. Copy of the queries below, and i've disguised tax id numbers for my organization. Query 1 - SELECT PR.LastName,PR.FirstName,PR.DisplayDegrees,PR.Npi,PR.Id,GR.GROUPNAME,EA.* FROM Visual_Cactus.visualcactus.EntityAssignments as EA Join Visual_Cactus.visualcactus.Providers as PR on EA.Provider_K = PR.Provider_K Join Visual_Cactus.visualcactus.PROVIDERADDRESSES as PA on PR.Provider_K = PA.PROVIDER_K Join Visual_Cactus.visualcactus.GROUPADDRESS as GA on PA.ADDRESS_K = GA.ADDRESS_K Join Visual_Cactus.visualcactus.GROUPS as GR on GA.GROUP_K = GR.GROUP_K WHERE EA.OriginalAppointmentDate >= DATEFROMPARTS(YEAR(GETDATE()),MONTH(GETDATE()),1) and EA.Entity_K like '%TCHN' and GA.TAXIDNUMBER in ('xxxxxxxxx','xxxxxxxxx','xxxxxxxxx','xxxxxxxxx','xxxxxxxxx','xxxxxxxxx','xxxxxxxxx','xxxxxxxxx','xxxxxxxxx','xxxxxxxxx',) Query 2 SELECT EAAD.*,GA.GROUP_K,PR.LongName,AD.AddressLine1,AD.AddressLine2,AD.City,AD.State,AD.ZipCode,EA.Assignment_RTK FROM Visual_Cactus.visualcactus.Addresses as AD Join Visual_Cactus.visualcactus.PROVIDERADDRESSES as PA on AD.Address_K = PA.ADDRESS_K Join Visual_Cactus.visualcactus.Providers as PR on PA.PROVIDER_K = PR.Provider_K Join Visual_Cactus.visualcactus.EAADDRESSES as EAAD on PA.PROVIDERADDRESS_K = EAAD.PROVIDERADDRESS_K Join Visual_Cactus.visualcactus.EntityAssignments as EA on EAAD.EA_K = EA.Ea_K Join Visual_Cactus.visualcactus.GROUPADDRESS as GA on AD.ADDRESS_K = GA.ADDRESS_K WHERE EAAD.ACTIVE = '1' and EA.Assignment_RTK in ('D2GT0MDZ4G', 'D2EK0KVTUN', 'D2ER0FKD24', 'D2ER0FJWWG', 'D2ER0FGOP7', 'D2ER0FG8HL','C4I80SMAER','P36Y0ZCIX4','D2ER0FFJ74','D2ER0FE95G','D2ER0FDEUF','D2ER0F9KQ0','D2ER0FA7YH','C4V60N6TTC','D2ER0F7FBI','D2ER0F6PN4','D2OE0KNTKW')
