Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Derik Hammer

SQLServerCentral.com profile

   Items 1 to 3 of 3   
 

Query the execution plan cache

This query will find the execution plans stored in the plan cache for an object that you specify in the WHERE clause.  Read more...
By Derik Hammer 2014/10/02 | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 1,336 reads

Find Transactional Replication Publisher

Finds the publisher, publisher database, and publication that your subscription table is replicated from.  Read more...
By Derik Hammer 2014/06/27 | Source: SQLServerCentral.com | Category: replication
Rating: (not yet rated) |  Discuss |   Briefcase | 351 reads

Find Transactional Replication Source from Destination Table

I wrote this script to help me locate the publisher, publication, published database, and source object for destination tables which might not be named the same or when you are in a large replication topology with dozens of publications.  Read more...
By Derik Hammer 2014/06/25 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 463 reads
   Items 1 to 3 of 3