-- Try this.

use pubs

Select RowNumber = Count(ut1.pub_id)

,ut1.pub_id, ut1.pub_name, ut1.[city]

From dbo.publishers ut1 With (nolock),dbo.publishers ut2 With (nolock)

Where ut1.pub_id > ut2.pub_id

Group By ut1.pub_id, ut1.pub_name, ut1.[city]

Order By 1

-- Try this.

use pubs

Select RowNumber = Count(ut1.pub_id)

,ut1.pub_id, ut1.pub_name, ut1.[city]

From dbo.publishers ut1 With (nolock),dbo.publishers ut2 With (nolock)

Where ut1.pub_id > ut2.pub_id

Group By ut1.pub_id, ut1.pub_name, ut1.[city]

Order By 1

/*create procedure spTestError

as

begin

  select * from sysfiles

  -- this will fail when called 2nd time

  select * into DummyTable from sysfiles

end

/*

You do not have a return value here.

Must be...

I have noway of knowing your name, but anyway, your solution is perpect and it work exactly what I always have wanted.

Again, With the references and scripts you all offered,...

Thank you very much Good Hunting,

I really appreciate your opinion, and I value it. And I must say that your opinion very helpful.

Thank you again.

Yes, I did have a table...

First, thank you very much for your prompt answer. I am really appreciated that.

I already have implemented a job to monitor the process using time control as what you have...