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...

And some examples of actual data in the tables, along with the CREATE TABLE code..

In SQL 2000 there was the ability to script out database objects with SQL code. I saved the files and copied them to my 2005 server and it works there....

I'm pretty sure the seeding would start back at 1 .... I have not tested.

You want the seeding for Table_1 in Database_B to continue with the current value in...