How to get Database Last Connection time for SQL server ?

• Pramod Ingle

  Grasshopper

  Points: 10

  More actions

  August 23, 2005 at 1:04 am

  #94697

  Hi,

  How to get Database Last Connection time for SQL server ?

  Also, can we retireve the database information of all servers in my domain through the query?

  Thanks and regards,

  Pramod 

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  August 26, 2005 at 9:24 am

  #585474

  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

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**