can we send a message?

• Saravanan_tvr

  SSCarpal Tunnel

  Points: 4558

  More actions

  April 8, 2009 at 1:29 am

  #219891

  If we need to know , which host (machines) are accessed our Database with the help of

  Sysprocesses , Such a way can we send a message for the machine ..

  in sql server..

• arun.sas

  SSChampion

  Points: 11831

  More actions

  April 8, 2009 at 2:58 am

  #974089

  Hi saravanan,

  In Sysprocesses the col DBID shows the database id and from sysdatabases you get the database name against this DBID

  ARUN SAS

  🙂