the problem is that these jobs are owned by a windows domain user !

They get authorised every time the job is launched by sqlagent....

-those are also the only ones in use overhere

FYI with SQL2005 I altered -T1204 to -T1222 altough it was not mandatory

- we also alter the Audit level from none...

I completely overlooked the s.ord_num as being the sortordernumber you wanted to use. That's why I added my own ordercol containing 0 or 1.

how about this

select maintitle

from (

select -1 as...

in your case, the "go"-solution will not work !

You're stuck with Mike John's solution.

Maybe a "select @cnt" may serve you well enough...

how about :

select maintitle

from (

select 0 as ordercol, 'this book at top of the list' AS 'maintitle'

union

select 1 as ordercol, t.title AS 'maintitle'

from titles t, sales s

where t.title_id = s.title_id

)...

maybe the "dodgy" GO statement can help you out..

print 'myfirtsnotification'

go

work work work

go

print 'mysecond notification'

go

.....

Keep in mind when using the GO, you'll loose all declared variables (or have to redefine them...

you may want to refresh statistics before you go on ...

print

'-- Usage ' + db_name()...

- it's useless to create the index if there is only one value. The chance of it being used is fairly equal to 0

you are always performing a full table scan because you did not provide an index for [ProducerId]

This way (b)locking and waits will occur !!

Jus create an index on...

- Is this meaning you want your column "workfunction" to be a bitmap ?

    check out the implications !!

    - http://www.sqlservercentral.com/columnists/dpoole/usingbitstostoredata.asp

- you would need a function with cursor (or temptb)...