This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi, I'm wondering if there is a simple way to script views definitions by some pattern, e.g. views in a particular schema and named using 'ndb' in the name? Thanks in advance.
Greetings, I need help with an issue I’ve been experiencing for the past month. Below is a short description of the problem: I regularly install Windows updates, and about a month ago I encountered an issue with installing the SQL Server update…
When converting a SQL script from SQL Anywhere to SQL Server, my code generated an error for the following CTE code sample; the error says that the column name used in the ROW_NUMBER function is invalid. Any suggestions on how to fix this would be…
we have a scenario where we have a sql server on 1 tenant that needs to be transitioned to Azure SQL Virtual Machine. Scenario: 1, Minimum down time migrate from 2016 SQL on windows 2019 to SQL 2022 on windows 2022 Integration services need to be…
We created a new 24 vcore SQL Azure instance and are getting hangs for 81 minutes with no timeouts on an update which previous took seconds. There is only one user and no blocking session SELECT s.login_name, DB_NAME(r.database_id) AS…
Greetings Doing a project where customer requirements for 4096 key length. So does SQL 2019 support 4096 key length for TDE. SS
I created a job to export 4 SQL 2019 tables to an Excel workbook using the Export Data task to create the SSIS package in SSMS. The process works fine in SSMS but when I run the created SSIS package in SQL Agent, it fails due to access denied. It seems…
What is the timeline for the release of the NEXT GEN feature for managed service in Azure? It has been in testing since March 2024. When will it be out of preview mode for general use?
Suddenly getting this error when using SSMS Import/Export Wizard and importing from Excel spreadsheet.
I am using SQL Server and Visual Studio 2022 for a language database, but I am unable to insert characters from this page for the Bassa Vah script (https://scriptsource.org/cms/scripts/page.php?item_id=character_list&key=16AD0). I tried NVARCHAR…
Hi Team, I am working on a SQL Server Stored Procedure which uses Output clause for Update Statement. Table getting updated is having a column name as ID. I need to put Try Catch in this SP and make sure that row which has errored, I am able to get the…
How to read the transaction log to re-create an insert statement
When tried to export my database that is in SQL database to bacpac got the errorFailed to export the database: nexxus-oltp-prod. ErrorCode: undefined ErrorMessage: The Export operation failed because database is larger than max supported size.
Hi Team, Could you please reply to below queries - Using CAST, I need to convert BigInt and Datetime2 values to Varchar. How could I be sure on the length that I need to use (in CAST) to convert these values to Varchar. I am using Update statement…
Hello. I asked this question on stackexchange and the guys from the community recommended me report it to Microsoft https://dba.stackexchange.com/questions/346386/trigger-on-cascading-update-target-doesnt-fire-when-the-output-clause-is-used Below is the…
What is the best method to copy all tables from DatabaseA to DatabaseB in an Azure Managed Instance, including all object-level permissions, triggers, views, and indexes? The Export/Import and SELECT * INTO methods are known not to retain object-level…
Details: I am running Microsoft SQL Server 2022 I am running DBCC CHECKDB on a user database (of which raised this error), each saturday This has happened on one on-prem Windows Server with installation of SQL server, with a predefined set of…
Hi All, I am trying upgrade SSISDB in SQL 2022 , The SSISDB backup I have copied from SQL 2014. While running ISDBUpgradeWizard I am getting below error. "TITLE: SQL Server Integration Services The version of the sql server instance (16.0.4175.1)…
Hi, Someone deleted my SQL Database instance name 'CroLahoreDB' early today 08:33 am, I want to know that how is it possible either it is cyber attack or my Account is compromized or some virus? How can I check it? please guide me. Regards Mubashir Ali
Hi when setting up StrechDB from an on prem server i get the error below Msg 40673, Level 16, State 1, Line 24 The service objective assignment for the database has failed This happens when i run the following script ALTER DATABASE XXXXXXX SET…