I've written the following stored procedure: CREATE PROCEDURE dbo.usp_DEMO @LOGINSQL VARCHAR(30), @DBNAME VARCHAR(40) WITH EXECUTE AS owner AS DECLARE @SQL NVARCHAR(1000) SET @SQL = 'USE' ...

Getting an error below when restoring a AdventureWorks2017 database within a docker container. Running SQL Server 2019 CTP 2.0 (mcr.microsoft.com/mssql/server:vNext-CTP2.0-ubuntu) Both backup and t...

I have a SQL Server Express instance on my machine that had been working fine and I have no idea what changed. I get this error now: Logon failed for login 'myusername' due to trigger execution. C...

I can't install SQL Server 2019 on my Windows 11 machine, because it fails to start Database Engine Services and I do not understand why. This is my personal computer and I have full access and all...

I'm trying to perform a PIVOT but getting an error. I'm trying to see which patients have more than one Interval session. The column is a text type. I attempted to convert the column type to VARCHA...

How can I run a named SQL Server instance inside a Docker container? I have an application that has a connection string pointing to a named SQL Server instance, something like Data Source=HostName\...

Ok, this one has me stumped. I'm hoping it's not something stupid/obvious... I'm trying to fix addresses in a client database. I have a function that takes a string and returns a string where the f...

I already had SQL Server 2019. After upgrading my Windows 10 to latest October Update, I found my SQL Server does not have latest service packs. I downloaded latest service pack CU8 from Microsoft ...

I'd like to split the result from a query and display the values in separate columns. As an example I get the following result |Name | |ABC_DEFG_HIJKL| |A_B_C | |A_B_C_D | I want to split the valu...

Say I have a table Schema.table with these columns id | json_col on the forms e.g id=1 json_col ={"names":["John","Peter"],"ages":["31","40&q...

I am using the mcr.microsoft.com/mssql/server:2019-latest container and want to mount its data directory so that data does not get lost if the server goes down. Where inside is the data directory l...

Just like any retail business we have an Orders table and an Inventory table. What I am trying to do is to check Orders for which we have enough stock available to dispatch. A few things I need to ...

With SQL Server Express LocalDb 2012 (Microsoft MSI download) it was possible to do an unattended install from a command line: msiexec /i SqlLocalDB.msi /qn IACCEPTSQLLOCALDBLICENSETERMS=YES Th...

here's my sample code drop function rowcount_test go CREATE FUNCTION dbo.rowcount_test () RETURNS INT AS BEGIN DECLARE @v INT SELECT @v = 1 return @@ROWCOUNT END GO grant exec on dbo.rowcount_t...

According to this link, SQL Server machine learning service's highest R version is 3.3. Does anyone know when one can upgrade to version 3.5 or later? Or is my only option to switch to sql server...

We are migrating to SQL Server 2019 RTM version and noticed that one of our stored procedures that uses SET IDENTITY_INSERT ON/OFF statements are failing which works properly in SQL Server 2017 and...

Good morning, My first question is how to determine if tables created in MS SQL Server are memory optimized. I have some tables and I don't remember if some of them I created in-memory optimized o...

I use the SQL Server 2019 Import and Export wizard to import an Excel sheet (xlsx file) as source and I set the destination as a SQL Server table. In the wizard setup I setup the mapping for ...