you can send a message to a user via current activity by right clicking on user connection and 'send messgae' in sql 2000 - but can u do this in sql 2005 as this feature doesn't appear to be available - i've asked other dbas and they don't know about this.
No it is not available, why do you want to do this when you can find that a connection is initiated by an user.
hi satya - if i want to send a message to a client/user via a specific process - how can i do that in 2005/8 ?
If you are able to identify the particular client/user process from Activity Monitor then send an email (database mail) using a job for long runnign processes.