how to displays the procedures currently running at startup on sql sql server 2000 ?

• zoltix

  SSC Eights!

  Points: 813

  More actions

  February 6, 2006 at 4:41 am

  #152733

  how to displays the procedures currently running at startup on sql[solved]

• G.R.Prithiviraj Kulasingham

  SSCarpal Tunnel

  Points: 4105

  More actions

  February 6, 2006 at 8:44 am

  #618996

  Hi,

  I am not sure of your question.  Do you want to find the procedures run during startup or the procedures currently running?

  to Find the procedures run during startup, you can run this code against master database:

  select * from sysobjects where (OBJECTPROPERTY(id, N'ExecIsStartup') = 1)

  To find the running processes you can execute (again against master db)

   Select * from sysprocesses

  if you need to find the test, you can try a system function fn_get_sql.  for this, you need to pass the sql_handle from sysprocesses.  the code syntax is:  select * from ::fn_get_sql(@handle)

  you can also try with profiler

  Hope this may help you 

  Cheers,
  Prithiviraj Kulasingham

  http://preethiviraj.blogspot.com/

• zoltix

  SSC Eights!

  Points: 813

  More actions

  February 7, 2006 at 12:12 am

  #619169

  I was the solution,

  select * from sysobjects where (OBJECTPROPERTY(id, N'ExecIsStartup') = 1)

  Thank a lot ........