I wanted a quick way to execute a TSQL command against all databases. I was having hard time getting the sp_MSforeachdb to work and didn’t want to write a cursor, so I instead built a TSQL command which makes the commands I need to execute. Not fancy, but it got the job done. –Command to
Read More »
Provided by: Suresh B. Kandoth, SR Escalation Engineer, Microsoft SQL Escalation Services These 2 scripts are used by the SQL Server Replication Support team to help analyze the Filter Logic used in Merge Replication. The first lists all defined Subset and Join filters. The first listing shows published table with indexes, the second listing shows
Read More »
content provided by: Akbar Farishta, Technical Lead, Microsoft SQL Server Support I wanted to post an update to Snapshot Agent Performance –MaxBCPThreads blog posting. We recently encounter a performance problem trying to push a 120gig snapshot down to a subscriber. The Distribution Agent was taking a long time doing a Bulk Insert on an 80gig
Read More »
Have you seen errors like these below when attempting to run SQL Replication Wizard or start a SQL Agent job? TITLE: Microsoft SQL Server Management Studio —————————— SQLServerAgent is not currently running so it cannot be notified of this action. (Microsoft SQL Server, Error: 22022) SQL Server blocked access to procedure ‘dbo.sp_get_sqlagent_properties’ of component ‘Agent
Read More »
Vijay Rodrigues | Microsoft SQL Server Support SQL Server Management Studio provides a way to monitor events, such as replication agent events, using alerts. SQL Server includes a set of predefined alerts for replication agents. If you would like to start the monitoring for replication agent failures, please follow below steps. The below is configured
Read More »