Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2006
    Posts
    31

    Unanswered: Trigger on Database Startup

    Hi, I'd like to create a trigger to fire it when database starts up. Is there any way to do it? If yes, would you be able to provide me with an example?

    Thanks in advance.
    -Alla

  2. #2
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    there's a way to make a proc run on startup. can't remember now how to do it.

    EDIT: had to look it up...

    exec sp_procoption N'MyProc', N'startup', N'true'

    http://msdn2.microsoft.com/en-us/library/ms181720.aspx

  3. #3
    Join Date
    Nov 2006
    Posts
    31
    Thank you so much!

  4. #4
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    that kind of thanks is so much better than "thanks in advance"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •