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.
    Trev256b, Aug 10, 2011
    #1

  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.
    satya, Aug 11, 2011
    #2

  3. Trev256b Member

    just checking if there is that option - why was this deprecated?
    Trev256b, Aug 27, 2011
    #3

  4. FrankKalis Moderator

    Not entirely sure, but I guess now there is Service Broker...
    FrankKalis, Aug 28, 2011
    #4

  5. satya Moderator

    ... also other means of communication is available.. so no use
    satya, Aug 31, 2011
    #5

  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 ?
    Trev256b, Sep 4, 2011
    #6

  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.
    satya, Sep 8, 2011
    #7

  8. Trev256b Member

    do u know what stored procedure i can use to send email to db user?
    Trev256b, Sep 25, 2011
    #8

  9. satya Moderator

    Look at the books online for code samples and explanation about SP_SEND_DBMAIL in this case.
    satya, Sep 28, 2011
    #9

Share This Page