I used the NULLIF function to capture the change, this works for all values and is the same for all types

SELECT GETDATE(), 'U', CONVERT(VARCHAR(255),@@SPID), SYSTEM_USER, HOST_NAME(), ISNULL(APP_NAME(),'unknown'),...

There are a few more registry setting to be made, all listed in https://businesswintelligence.com/content/42/enforce-tls-strong-crypto (thanks to Pedro Salina-Ruiz) Setting these values and forcing a restart of the Database...

Thanks ashepherd,

The emails are similar but have different content, it looks completely random whether the mails are sent or fail.

The solution you gave (registry items) was done more than a...

The registry key were already added some time age, but that didn't make any difference.

Whenever I need to create an alias, i use the following powershell script, it creates an SQL alias for 32 and 64 bit versions.

#Name of your SQL...

DECLARE @d int = 1
RAISERROR (' %s is the current value', 1, 0, @d)

Running this result in error 2786, The data type of substitution parameter 1 does...

The result on my setup of  SQL 2019 is also 8000, I have the same thought as Rune that the intended character is not the character in the question.

I agree with Frederico, the 'correct answer' is not correct, the no. of processors is not mentioned in the question.

I agree with magnus that -m is not a flag for the @@CURSOR_ROW function, i only indicates in BOL that a negative value returned by the function indicates that the...

This would only work if a database with the variable name would exist...

There is no correct answer here.

Louis.

Same with me, copied, ran the code and wrong answer.

The line in the published code ends with a space, not with a backslash.

My Result when running the entire batch:

Processed 4 pages for database 'test', file 'test_log' on file 1.

BACKUP DATABASE WITH DIFFERENTIAL successfully processed 5108 pages in 1.766 seconds (22.594 MB/sec).

Running the...

The correct answer seems to be wrong ?

Louis,

Another option it to dynamically create the resulting table.

Starting from a table with all the items and an empty price column, and loop through all the price lists.

In each loop...