DECLARE @Command nvarchar(4000) SET @Command = N'DROP INDEX [NoClient] ON [Invoice]' PRINT @CommandThis would work to replace it with this:
DECLARE @Command nvarchar(4000) SET @Command = N'DROP INDEX [NoClient] ON [Invoice]' Raiserror(@Command,0,1) With NowaitBut, I need this:
DECLARE @Command nvarchar(4000) SET @Command = N'DROP INDEX [NoClient] ON [Invoice]' Raiserror(@Command+'...',0,1) With NowaitAnd, this does not work. It seems Raiserror() has no support for concatenation with such syntax.
PRINT 'Processing Report at '+convert(varchar,datepart(hour,getdate()))+':'+ RIGHT(REPLICATE('0',2)+convert(varchar,datepart(minute,getdate())),2)+':'+ RIGHT(REPLICATE('0',2)+convert(varchar,datepart(second,getdate())),2)+'...'Will not work when being converted to this:
Raiserror('Processing Report at '+convert(varchar,datepart(hour,getdate()))+':'+ RIGHT(REPLICATE('0',2)+convert(varchar,datepart(minute,getdate())),2)+':'+ RIGHT(REPLICATE('0',2)+convert(varchar,datepart(second,getdate())),2)+'...',0,1) With Nowait