Following a user database restore the database had orphaned users. We used TSQL commands below to build a list of sp_change_users_login commands in order to resynchronize database users with SQL logins. We then ran these sp_change_users_login commands to automatically fix the users. In SQL 2005 and SQL 2008 the SQL login is created and automatically
Read More »
José Moreira Neto | Microsoft SQL Server Escalation Services sp_addpublication parameter: [ @immediate_sync=] ‘immediate_synchronization’ Immediate_sync has a default of FALSE. independent_agent must be true for immediate_synchronization to be true. Immediate_sync feature instructs Replication to maintain Snapshot BCP files and distributed transactions in the Distribution database should a new subscriber be created (or reinit) within the
Read More »
Windows Synchronization Manager on x64 SQL 2005 BOL topics describe how to launch the Windows Synchronization Manager to synchronize a subscriber. How to: Synchronize a Subscription Using Windows Synchronization Manager (Windows Synchronization Manager) http://msdn.microsoft.com/en-us/library/ms151863.aspx On x64 system, the BOL steps will start the x64 Win Sync Manager not the 32bit version. The x64 bit will
Read More »
José Moreira Neto | Microsoft SQL Server Escalation Services Particularities of Merge Anonymous Subscribers In Merge Replication, anonymous subscriptions are required if you want to create a subscription without registering the subscription at the Publisher. This is necessary for cases in which you cannot establish a SQL Server connection to the Publisher during subscription configuration.
Read More »
Doing Replication demonstrations on my laptop I’ll notice a Distribution Agent is not running. I’ll start the Agent and Refresh, but it still shows as Not Running. Looking at the Agent Details it appears it was running then stopped. Yet when I start synchronizing the status never changes and the DETAILS don’t update. The Last
Read More »