Setting up Service Broker where the initiator database is part of the AG

  There have been several posts on setting up Service Broker where the database is part of the Availability Group. This is a one stop blog for setting up Service Broker where the initiator database is part of the AG What happens when the AG fails over? Should there be any additional steps in setting…

1

Error configuring distribution- "Publishing and distribution are supported only in SQL Server version 7.0 or later"

  I recently installed an instance of SQL Server 2016 on one of my server. Later when I tried to configure the new instance as Distributor I faced the below error: Error: —————————— TITLE: Configure Distribution Wizard —————————— ‘Prod\SQL16’ cannot be configured for publishing and distribution. Publishing and distribution are supported only in SQL Server…

1

How to find which user deleted the user database in SQL Server

  In one of the recent scenarios we noticed that a user database was deleted and customer wanted to which user has dropped the database. We know that multiple user had full access on that database. In this post I’ll be sharing the steps to find the details of user who drop the database. Method-1…

5

Snapshot agent fails with Error: 241, Severity: 16, State: 1 (Conversion failed when converting date and/or time from character string)

ISSUE Let’s say you are monitoring Replication Agent status and noticed that the Snapshot Agent has failed with the following error while generating a snapshot, particularly during creation of BCP files. Error: 241, Severity: 16, State: 1 Conversion failed when converting date and/or time from character string. To further investigate the above error and to…

1