Look in sysjobhistory for jobs whose most recent entry doesn't have step_id = 0. That will tell you the jobs that are currently running. You will then have...

Are you just looking for currently running jobs that have been running for more than a certain length of time? If so, why do you need sysprocesses?

John

Since NULL means "unknown", you can't know whether NULL is 0 or not. Therefore NULL<>0 cannot be evaluated as "True". This is why you need to be very...

Ah yes, good point. I think that would have been a better way to put the question.

John

IgorMi (6/8/2012)

---

Try with XACT_ABORT = OFF and you'll see the same results as it is ON. In this case XACT_ABORT does not have impact of the inserted rows. However on...

IgorMi (6/8/2012)

---

I don't agree with you.

Ensured with a direct try.

You can execute the following code and ensure yourself that the IGNORE_DUP_KEY = ON has done its effect.

create table qotd5

(

col1...

I got this right, but I'm still a little confused. Am I correct in thinking that what is being tested here is knowledge of the IGNORE_DUP_KEY setting and not...

Barry

How do you configure the server name for the connection string? Do you use a dtsConfig file, or a SQL table, or is it hard coded? Does the...

You can use the Execute Process task in SSIS.

John

Michael

The only thing that I can think of is that there's another piece of code somewhere that's creating a temp table with the same name. You can run a...

You'll need to find a way of assigning NULL to the variable that you pass in. If you can't do that, change the stored procedure so that it treats...

Michael

What kind of table are you creating - temp table, global temp table, or table in a user database? Are there multiple instances of the same package running at...

If you look on the Books Online page for sp_spaceused, you'll get your answer.

John

What account does the IBM Scheduler run under? Does that account have access to the databases?

John

Mal

We use LiteSpeed, but when I unsuccessfully tried to do an object level restore, I raised a call with Quest. They told me that our licence doesn't cover that....