FOUND THE ANSWER, IT'S A WINDOWS PATCH!!!!

http://stackoverflow.com/questions/28542537/an-error-occurred-during-service-master-key-decryption

"Windows patch, KB3004375 ("Update to improve Windows command-line auditing"). After removing this security patch, there are no more errors"

I think this is what you are looking for...

http://databases.about.com/od/sqlserver/a/bcp.htm

I use to upload files using bcp bat files. It will insert all rows for you.

Yes Perry I know, I...

Why would you want to put your replica on a stand alone for DR? The AlwaysOn option was built for DR auto failover...hence the name High Availability. I wouldn't recommend...

I found out what was going on, there is NOT an option in SharePoint to do TDE Database Encryption. There is however a SSL for website encryption. The DBA that...

yes, I am running the to set the flag in master, I just need a loop to alter but it looks like I cannot. I was hoping to place it...

I would put a call into MS Support and ask them.

Any other ideas?

There's a way in SQL to find the query, I just got out of a class with MS that showed us and I can't find the query. If I find...

Hey Perry,

SO I can create the users and it will work until a failover? Also I only used sp_help_revlogin on node one to create user on node two. I scripted...

Hey Perry,

We went from SQL08R2 P-V one node cluster, I know, I know, before me, to SQL 2012 AlwaysOn.

When they were created about a month ago, I used sp_help_revlogin. I scripted out the users on the old server, created on the primary node, used sp_help_revlogin to get the...

http://www.databasejournal.com/features/mssql/article.php/1438201/Setting-Up-Transactional-Replication-A-Step-by-step-Guide.htm

roadkillchicken (7/25/2014)

---

Hi all,

I have a quick question, hopefully someone can point me in the right direction.

We have two SQL 2012 servers, sever A and B.

We need to sync a database...

Great, let us know what they say. 🙂