Technical Article

Mirroring Job Switcher

I wrote this so that jobs associated with a mirrored database will run on the principal and not on the mirror.  Please send your comments on what implications I might be missing - I would appreciate that greatly.This procedure works in conjunction with a WMI alert you will setup in SQLSEVERAGENT -> Alerts ->Mirroring Status […]

You rated this post out of 5. Change rating

2007-09-04 (first published: )

461 reads

Blogs

Using a tnsnames.ora file with the Microsoft Connector for Oracle in SSIS

By

One of the nice things about the Microsoft Connector for Oracle is that it...

ChatGpt Experiments–Getting Documentation

By

I get asked questions by salespeople all the time. Usually this is because a...

A New Word: Jouska

By

jouska – a hypothetical conversation that you compulsively play out in your head –...

Read the latest Blogs

Forums

Can't Restore DB

By water490

hi everyone I need to get a copy of a stored proc from backup...

How Can I Speed This Query Up?

By water490

Hi everyone My SQL query is close to 1000 lines with 17 separate calcs...

partitioning a huge table

By anoop.mig29

Hi folks I would like to get your views about  partitioning  a huge table...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers