First question is probably does the following file exist:

C:\SQL-backups\ODM\ANALYTICS_RESULTS_backup_2016_10_26_060001_4910167.trn

If it does exist, rename it (it may be corrupted), and retry the backup.

Looking at your post a second way, you may be asking if ASP can run on the latest version of Windows (currently Windows 2012 R2, if it is not confusing...

Well, to be unbearably pedantic, no, you can not run ASP on SQL 2016. You would need IIS to run ASP code. ASP code running on an IIS...

Mostly the same as writing a report on SQL Server. Of course, the data set will have to be written with Oracle syntax, so there are certain functions you...

Do you mean via Extended Events?

Those datatypes are still available in SQL 2014 (probably SQL 2016 as well. Can't test at the moment). Just be sure that you don't have one lurking around....

Function-wise, there should be no difference. You should check on the %PATH% variable to see which utilities will be preferred, as this can have effects on scheduled jobs that...

You don't need an alias at the OS level in order to do this (although, if you are using SSIS packages on the server, it may help). sp_addlinkedserver will...

I am not so sure this will work for all cases. Suppose you want to restrict something to two disjoint ranges (1 -> 5 and 10 -> 20). ...

You almost have it.

create table #test

(col1 int,

col2 int,

col3 int)

insert into #test values (null, 1, 2), (10, 11, 2), (1, 2, 3)

select *

from #test

where 1 in (col1, col2, col3)

I don't believe there is much harm in doing this, provided you have no jobs set up to start when SQL Server starts. I would probably look in to...

In all seriousness, I second this one. If this user's job does not include dropping or truncating tables, he/she should not have the right. If they are involved...

A login is by default created with a random SID. You can force a SID at creation time, so if you can take the downtime (which it sounds like...

As with any index, it will depend partly on how many records you are likely to have. If you only have about 10 records in the table, then LIKE...

If you were to run the sampled update of the statistics several times over, do the results stay substantially the same, or does the distribution estimate change from run to...