Before I make lots of changes on a production server, do you know which settings might apply to my situation ? That I can access the MySQL data via...

You could try looking at your transaction log backups, and see what time of day they were very large. Then try to figure out what was running at that time.

I...

I never solved it. I just omit results older than 'X' days.

I should note the downside to this approach is that you only get notified when the code runs, not when the job fails. I have many morning jobs that run,...

Oooops. Misplaced bracket.... Corrected it

should be like this:

and h.step_id > 0)-- only look at actual steps

Definately NOT clear text. The numbers were encrypted, and the database with the encryption key was in a separate database that was on an encrypted drive with only admin permissions....

We were allowed to store CC numbers, but had to have various safeguards in place to be PCI compliant.

This does not answer your question, but you might find it useful. We have some jobs with multiple steps and if a middle step fails (eg step 4), the job...

balasach82 (10/15/2013)

---

I have few columns like SSN, Creditcard details in the table which i dont want every one who has access to the table to see. Even if they see...

Looking through a server side trace that was running, and logs, I can not see a cause of failure.

What is your restore script doing ? Any chance it is using an older backup file by mistake, not the most recent one ?

I have made some progress, but not sure about how the data sources get defined on the original & standby servers.

Currently getting this error when trying to run a report:

An...

The vendor is doing this step ? SourceDB --> Repl_DB1

Using SQL replication, or another process ??

ChrisM@Work (10/1/2013)

---

This I reckon is the correct way to write your query:

select T2.COL1, T2.COL2, T1.COL1, T1.COL2, T1.COL3

from T1

join T2

on T1.COL4 = T2.COL3

where T2.COL4 != 'data1'

and T1.COL1 is not NULL

and...

Chris, is this the equivalent of a LEFT JOIN based on 4 columns ?

AND NOT EXISTS (SELECT 1 FROM T3

WHERE T3.COL1 = T2.COL1

AND T3.COL2 = T2.COL2

AND T3.COL3...