SP1 for SQL Server 2014 has been pulled back and delayed.

Good. Are you on Service Pack 1?

This is from https://technet.microsoft.com/en-us/library/ms151718%28v=sql.105%29.aspx

User-Defined Triggers

If the application requires triggers at the Subscriber, the triggers should be defined with the NOT FOR REPLICATION option at the Publisher...

Run this and see if it returns anything:

SELECT * FROM sys.dm_exec_requests where command like '% LOG%' or command like '% CHECKPOINT%' or wait_type like '% LOG%'

Jeffery Williams (3/19/2015)

---

I have been able to encrypt a column however I can not decrypt it; please help:

Ok pretty new to encryption. Did it once YEARS ago. The following is...

Yes you can restore and reinitialize but I'm not sure if you need to add a new server as a subscriber first.

NO. compatibility level controls the features not database internals.

Job saving tip:

Never ever allow 3rd party (even if it's Microsoft System Center 2012) handle backups.

But 🙂 it depends on your situation.

You used wildcard %430% in like so why not use in contains WHERE CONTAINS(CustomerID, '"*' 430 '*"')

You just mentioned replicate so by setting up replication you can accomplish it.

For Always On to work you must have Enterprise Edition installed in every site.

Here is some reading material...

Because you're telling the server to only create the table IF NOT EXISTS.

IF NOT EXISTS is a conditional operation actually your code is 2 conditional expressions and a transaction in...

You can't use case statement in merge the way you described.

I don't think you need case in merge

Just like in the join you can add additional conditions and you can have multiple WHEN (NOT) MATCHED conditions

WHEN MATCHED AND (src1.col1=NULL AND...

Kenneth and Gail Thank you very much 🙂

is_cdc_enabled was 0 but the log_reuse_wait_desc = REPLICATION.

I followed Gail's steps and was able to resolve it.

Just use PRINT or SELECT that @ variable which contains the dynamic sql and comment out the

e.g.

--Exec @sql

--execute @ variable