Hi,

It is not the first time you are asking the same question. From the provided information is not obvious what is happening on your server. Can you publish a XML deadlock...

You can do this but bare in mind that the only server will have that name either one with the SSAS instance or one with other instances.

Another option is use a dynamic SQL.

Hi,

If you have different variation of parameters you can do something like

if(@style = 1)
begin

SELECT *
FROM OPENJSON(@json)
WITH(
idn int '$.id',
name NVARCHAR(50)...

You have forgotten one quote mark in the line - set @cmd = ''''use [' + @name + ']; and one in the line ''''.

Hi Netanel,

You can check that out in the example database - https://github.com/Microsoft/sql-server-samples/releases/download/wide-world-importers-v1.0/WideWorldImporters-Full.bak

Why don't you use the backup and restore from MS Management Studio?
https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/restore-a-database-backup-using-ssms

There is a way how to contribute a script - http://www.sqlservercentral.com/Contributions/Home 😉

ORDER BY