SELECT * FROM sys.sysprocesses WHERE waittime >120000 ???

• jagpalsingh4

  Ten Centuries

  Points: 1311

  More actions

  May 1, 2008 at 4:46 am

  #123709

  Hi,

  will u plz tell when i try to run this query in sql 2000 its not working .Because in sql 2000 there is no dmv of sys.processes so will u plz tell me where can i look for this.Any suggestion ???

  SELECT * FROM sys.sysprocesses WHERE waittime >120000

  Thaxxx

  jagpal singh

• Carl Federl

  One Orange Chip

  Points: 25384

  More actions

  May 1, 2008 at 6:01 am

  #809483

  Under SQL Server 2000, "sys.sysprocesses" is not a known table and you should use "master.dbo.sysprocesses".

  SQL = Scarcely Qualifies as a Language