SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: April 2015

Error Creating Remote Distributor When Creating a Local Distributor

Recently, I was working on a Peer-to-peer replication automation project. When I switched from my local test servers to some lab servers to test my scripts, I ran into some issues. The thing that confused me at first was that it was complaining about a missing remote login for the…

Read more

T-SQL Tuesday #65 – Overcoming Variable Limitations in SQLCmd Mode

It’s time again for that T-SQL blog party T-SQL Tuesday, and this month’s host is Mike Donnelly (blog|@SQLMD). If you want to join in the blog party, take a look at Mike’s announcement for an explanation of the topic and rules for participating: T-SQL Tuesday #065 – Teach Something New.…

Read more

Patching Master Data Services

I recently installed my first deployment of Master Data Services (MDS). I installed the SQL Server 2014 (Enterprise Edition) MDS front-end on a new server with the intent to use an existing SQL Server 2014 (Enterprise Edition) database engine for the back-end. Unsurprisingly, I ran into some issues, and as…

Read more