PC Review Forums Newsgroups Microsoft DotNet Microsoft ADO .NET how to displays the procedures currently running at startup on sql sql server 2000 ?

Reply

how to displays the procedures currently running at startup on sql sql server 2000 ?
 
Thread Tools Rate Thread
Old 06-02-2006, 11:46 AM   #1
zoltix
Guest
 
Posts: n/a
Default how to displays the procedures currently running at startup on sql sql server 2000 ?




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

*** Sent via Developersdex http://www.developersdex.com ***
  Reply With Quote
Old 07-02-2006, 07:16 AM   #2
zoltix
Guest
 
Posts: n/a
Default Re: how to displays the procedures currently running at startup on sql sql server 2000 ?
This is the solution

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

*** Sent via Developersdex http://www.developersdex.com ***
  Reply With Quote
Reply

Archive


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off