I think that you are misusing the XML. You have the same elements' names for different information. The only way to know what is the real information is...

There are 2 problems with your code. You cannot concat datetime data type with varchar data type, so you need to convert your parameters to varchar data type (using...

You can use the function rank and compare its outcome to the function row_number. Here is an example based on your script:

CREATE TABLE #tblTasks

...

It does look like blocking issue. When you set the database to a single user mode, the process that was blocking you, was killed and the resources that you...

You need to add one more apostrophe. See my example bellow:

declare @Name varchar(10)

set @Name = 'O''braien'

SELECT CASE WHEN LEFT(@Name,2) = 'O''' THEN 'yes' else 'no' end, @Name

set @Name =...

The script that was given by sql driver, shows the size of log backup. While I agree that it has a connection to the log's size, it doesn't show...

If all you need is to round the number to an integer number or to omit the part that is right to the decimal point, then you can use the...

Check if you are using linked server (or synonym that uses linked server). If this is the case, then you need to modify the linked server's login's configuration.

Adi

repairs and upgrade:-).

Talking about getting it wrong. I completely misunderstood your needs. You really need to explain what you want. It would be helpful if you'll also have a small...

You didn't really specify the rules for your update. Currently we are mainly guessing the way that it should work. I wrote a small code that transform your...

Well, you are wrong. Checkpoint will occur. In fact one of the factors of that cause checkpoint is database backup. Of course there are other things that...

The SQL statement that you are using in the screen shot that causes the runtime error is different from the statement that you wrote in the original question. In...

I've just ran the small script that you can see bellow on SQL Server 2012 and it worked without any problems, so I don't think that the problem is that...

You can test it for your self by creating a deadlock and then check that you see it's details in the error log. Here is a small script that...