Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Location
    bangalore
    Posts
    270

    Unanswered: Trigger - Microsoft SQL Server Management Studio

    Hi,
    How to create Trigger in "SQL SERVER 2005 - Microsoft SQL Server Management Studio"? This is my 1st interaction with SQL SERVER 2005.



    Thanks,
    Rahul Jha

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by DBA_Rahul
    Hi,
    How to create Trigger in "SQL SERVER 2005 - Microsoft SQL Server Management Studio"? This is my 1st interaction with SQL SERVER 2005.



    Thanks,
    Rahul Jha
    Um...try
    Code:
    CREATE TRIGGER [trigger_name] ON object_name]
    FOR [INSERT, UPDATE, DELETE]
    
    AS
    ???

    Seriously, you can select View/Template Explorer from the menu at the top and then find the trigger templates down towards the bottom. Step away from the GUI...

    Regards,

    hmscott
    Have you hugged your backup today?

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    ...step towards Books Online...
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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