SQL Server Database Migration Migrating a database is very critical and time bound process, if anything goes wrong then its very difficult to rollback things and move back to existing environment again. So its very important to prepare a checklist before...
HOW To modify a synchronization schedule for a pull subscription in Management Studio Connect to the Subscriber in Management Studio, and then expand the server node. Expand the SQL Server Agent folder, and then expand the Jobs folder. Right-click the...
HOW To modify a synchronization schedule for a push subscription in Management Studio Connect to the Distributor in Management Studio, and then expand the server node. Expand the SQL Server Agent folder, and then expand the Jobs folder. Right-click the...
HOW To modify a synchronization schedule for a push subscription in Replication Monitor Expand a Publisher group in the left pane of Replication Monitor, expand a Publisher, and then click a publication. Click the All Subscriptions tab. Right-click a...
HOW To specify synchronization schedules REPLICATION? On the Synchronization Schedule page of the New Subscription Wizard, select one of the following values from the Agent Schedule drop-down list for each subscription you are creating: Run continuously...
Cursor Advantages and Disadvantages Cursor advantages: Using cursor to getting multiple values. One cursor have multiple select statements Cursor parameters cursor cursor_name (parameter datatype) is select * from table_name where(condition) Where Current...
SQL Server Transaction Log There has always been some debate as to whether or not there are real benefits to be gained from accessing the information in the transaction log. This article will endeavor to answer that question by looking at the following:...
What type of locking occurs during the Snapshot generation? Locking depends on the type of replication used: In snapshot replication, the snapshot agent locks the object during the entire snapshot generation process. In transactional replication, locks...
Queue Reader Agent - The Queue Reader Agent is used with transactional replication with the queued updating option. The agent runs at the Distributor and moves changes made at the Subscriber back to the Publisher. Unlike the Distribution Agent and the...
