I was playing with SQL Azure on my brand new Surface pro device. I open the Windows Powershell ISE as administrator to import AzureRm module by running the below command; Import-Module AzureRm It returned this error: PS C:\windows\system32> C:\Users\User\Desktop\Azure Script.ps1 File C:\Users\User\Desktop\Azure Script.ps1 cannot be loaded because running scripts is disabled on this system. For more information, see […]
Only one Log Reader Agent can connect to a database at a time error – Transaction Replication/CDC
Read more
An interesting issue regarding SQL Server Transaction Replication/CDC log reader agent job can’t be started with the following error: Msg 18752, Level 16, State 1, Procedure sp_replcmds, Line 1 [Batch Start Line 229] Only one Log Reader Agent or log-related procedure (sp_repldone, sp_replcmds, and sp_replshowcmds) can connect to a database at a time. If you executed […]