Processing step 'QBM DatabaseSettings_transactionmode_normal (DatabaseSettings_transactionmode:normal)' failed.
1 - Sql command failed.
Error running statement:
set lock_timeout 10000
declare @ErrorMessage nvarchar(1000) = '50000' + CHAR(9) + '2' + CHAR(9)
declare @cmd nvarchar(max)
declare @DBName nvarchar(128) = db_name()
if 0 = (select is_read_committed_snapshot_on
from sys.databases where name = @DBName )
begin
if exists (select top 1 1
from sys.sysprocesses p
where p.dbid = db_id()
and p.spid != @@spid
and isnull(p.status, '') != 'background'
)
begin
select @ErrorMessage = concat(@ErrorMessage
, '#LDS#Cannot switch transactionmode because of other users are active. {0}.|'
)
select @ErrorMessage = concat(@ErrorMessage
, '#LDS#Stop the other processes, please.|'
)
raiserror(@ErrorMessage, 18, 2 ) with nowait
end
select @cmd = concat('
alter database "' , @dbname , '" set READ_COMMITTED_SNAPSHOT ON '
)
exec sp_executesql @cmd
-- print 'READ_COMMITTED_SNAPSHOT switched'
end
--else
-- begin
-- -- print 'READ_COMMITTED_SNAPSHOT was OK'
-- end
set lock_timeout -1
Database error 137: Must declare the scalar variable "@dbname".
Must declare the scalar variable "@dbname".
