Error Message Msg 3734, Level 16, State 1, Line 187 Could not drop the primary key constraint ‘PK_Person_BusinessEntityID’ because the table has an XML or spatial index. Msg 3727, Level 16, State 0, Line 187 Could not drop constraint. See previous errors. Description: This error message appears when you try to remove a PRIMARY KEY […]

SQL Server Agent is running with Windows Credential with no roles assigned. Behind the scene Log Reader Agent Connect to the Publisher Database to read database log, master  and resource database to obtain license and version information. As we have not granted any sort of permission to the Agent Account at the publisher server ,so […]

While setting up Database mirroring I came across an error which is too common on the web but too much of workaround and solutions. Therefore I thought to write a blog post for the error. The problem we’re trying to solve is that you try to start database mirroring and you receive this error: The […]