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

SQL Geek

Dharmendra is a SQL Server/Microsoft Data Platform professional with over eight years of experience. He enjoys helping others in the SQL Server community and does this by contributing on blogs, speaking at several SQL events. His passion and focus is to explore and share more and more on SQL Server.

Archives: September 2018

Powershell Error – Import-Module AzureRm

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…

Read more

0 comments, 144 reads

Posted in SQL Geek on 19 September 2018

Only one Log Reader Agent can connect to a database at a time error – Transaction Replication/CDC

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…

Read more

0 comments, 2,014 reads

Posted in SQL Geek on 10 September 2018