Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2002
    Posts
    2

    Question Unanswered: scripting triger in sql server

    anyone out there to help me to find answer for these questins:

    1. how can i access linked sql server from triger.. ?
    2. is it possible to run any exe from triger

  2. #2
    Join Date
    Oct 2002
    Location
    Brussels, Belgium
    Posts
    5
    1:dunno

    2:look at the xp_cmdshell command

  3. #3
    Join Date
    Oct 2002
    Posts
    2

    Question

    thanks for ur post. unfortunately i am not aware of xp_cmdshell command. could u please tell me how can i use this command.

  4. #4
    Join Date
    Oct 2002
    Location
    Brussels, Belgium
    Posts
    5
    Well, I suggest you look in the online help for SQL server (books online).
    It's a T-SQL command, so I think you can use it in a trigger.

    i.e.:
    xp_cmdshell 'dir *.exe'

Posting Permissions

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