I was tring jan van der Goes's way but I get "Connection is busy with results from another command".

Ionel

From BOL "row ID (RID) comprised of the file number, page number, and slot number of the row"

Hi,

Have you tried to recreate the procedure WITH RECOMPILE?

Ionel

I think you can use this approach too

--table structure

CREATE TABLE [a4] (

[id] [int] IDENTITY (1, 1) NOT NULL ,

[title] [varchar] (50) ,

[name] [varchar] (50) NULL ,

CONSTRAINT [PK_a4] PRIMARY KEY ...

For the script that is looking for jobs still running I think an easyer script will be

msdb.dbo.sp_get_composite_job_info @execution_status = 1

since the rest of parameters has a default NULL.

Ionel