SQL Server Performance

can send a message to a user in 2005?

Discussion in 'SQL Server 2005 General DBA Questions' started by Trev256b, Aug 10, 2011.

  1. Trev256b Member

    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.
  2. satya Moderator

    No it is not available, why do you want to do this when you can find that a connection is initiated by an user.
  3. Trev256b Member

    just checking if there is that option - why was this deprecated?
  4. FrankKalis Moderator

    Not entirely sure, but I guess now there is Service Broker...
  5. satya Moderator

    ... also other means of communication is available.. so no use
  6. Trev256b Member

    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 ?
  7. satya Moderator

    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.
  8. Trev256b Member

    do u know what stored procedure i can use to send email to db user?
  9. satya Moderator

    Look at the books online for code samples and explanation about SP_SEND_DBMAIL in this case.

Share This Page