I think what I would do is alter your stored procedure so that it gives a return value of the number of rows inserted, then either insert that value into...

Sounds like you're looking at the design surface of your package, and not in...

Try it out. It also returns last_run_date and last_run_time, which gives the last time that the job started - whether it's still running or not.

John

Mmmm... that's a good point. SQL Server 2000 had an "In Progress" value for run_status, but that seems to have been dropped from later versions. One way round...

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