did you try this ?

Select PrimeKey, Col_A, Col_B, Col_C, Col_D, Col_A_B

from ( Select PrimeKey, A.Col_A, A.Col_B, A.Col_C, A.Col_D, B.Col_A AS Col_A_B,

RANK() Over(Partition BY A.Col_A, A.Col_B, A.Col_C, A.Col_D, order by...

You can do that using e.g. a scheduled task providing that wanted windows account as execution account of that task.

and then have that task execute the wanted sqlcmd using the...

Great feedback, guys ! :w00t:

Thanks.

to use Windows authentication use the parameter -E in stead of the -U and -pwd

ref:https://msdn.microsoft.com/en-us/library/ms162773.aspx

first of all, you only have to install the most recent CU.

First install that CU at the non-active node.

the you will have downtime ! for failing over the SQLinstance from...

Database mirroring in use ?

With regards to Error 18456 I always use Aaron Bertrand's article: Troubleshooting Error 18456

tt-615680 (9/25/2015)

---

Thank you for your help! I’ve tried to run the scrip but unfortatly I get the following error message, I have changed the location name where the transactional log...

Set-location "c:\myfolder\SQLBackups"

# List all files and order by LastWriteTime descending

get-childitem -Filter '*.BAK' | Select FullName, LastWriteTime | sort LastWriteTime -Descending | ft -AutoSize

# only the most recent file

$Bakfile =...

It depends.

What's the recovery model used by the source database ?

What's the final goal of your database ?

Do you need your target database to be in e.g. read-only state, Read-Write...

SET Statistics time, io on

...

Set statistics time, io off

SELECT ...

INTO [TraceMMdd]

FROM ::fn_trace_gettable('E:\Thermo\MSSQL12.MSSQLSERVER\MSSQL\Log\ALZDBA_SQL_Trace_..._20150630_0838_.trc', default)

an off course The Glenn Berry Diagnostic...

To keep the answer brief and firm: No.

The risk encountering...

As you know with AlwaysOn it's the little things that really matter.

Don't just set it up, but test it to the max before you go live.

And that includes Backup and...

It will...

GilaMonster (6/17/2015)

---

Hopefully the SQL 7 server has long since been relegated to the...

The big downside of using three part naming is during "same instance different DB-name recovery" !

This mostly happens to correct a mishap.

Hush hush repair may cause more damage due...