Yes I did remi - sometimes we do think alike!

there's nothing random about you at all remi...once things go into that head of yours it seems to be retained there for life....maybe a prom ?!?!

now, now remi - be nice...

besides erik - there's no other time ....unless remi moves to ny - in which case i'm withdrawing from ssc anyway....

rg - i seriously hope for your sake that you're not insulting my intelligence by suggesting that i did it because i tried to disappear...i did it in response to...

sue.. - qui est sue ?!?!

erik - i sent you a pm about an article that i recently submitted - did you...

peeps.. qu'est-ce que c'est - oh - people...no wonder you get your posts ahead of everyone else - you just use too many abbreviations...

pramod - see if this is what you want...

select program_name, login_time, last_batch, lastwaittype from sysprocesses

inner join

sysdatabases on

sysprocesses.dbid = sysdatabases.dbid

and sysdatabases.name = 'dbName'

order by login_time desc

agreed rg - i had also said "- do this in your tempdb database!"..

which's why I had suggested.."select * from sysobjects where name like '#%'"

when that happens - i'm opting for early retirement...

unless your new job actually has you working hard (like Frank who has now practically disappeared...

well - this thread is all about triggers anyway...maybe one of these days i can get to be the "fastest draw on the east coast"...

do you HAVE a test3 table ?!?!

HUH ?!?! ne comprends pas!

remi - reg. the "read receipt" i always get a message back to myself saying that i've read it...i mentioned it to steve once and i've...

smruti - are you sure you have a test3 table ?! you need to create it first!!!

FROM DELETED

also...the from part of it should be from Deleted..

remi - i find that i'm making a lot of mistakes just so i can get there ahead of you - now...