Post reply

Master/Target Server Script

  • May 4, 2009 at 7:34 am

    #208959

    Is it possible to set up a target server with a script rather than manually doing this from SQL Server agent?

    Does anyone know what system tables are involved?

    Thanks in advance.

  • May 4, 2009 at 11:11 am

    #988218

    are you talking about server event forwarding in sql agent?

    set it up how you want in ssms on one of your non-configured servers, then (instead of hitting OK) press CTRL-SHIFT-N

    it will create the script for you in a new window.

  • May 5, 2009 at 1:05 am

    #988574

    Hi, thanks for the reply but it's the making a server into a target server and then selecting the master server rather than the event forwarding, I tried your suggestion as the screen doesn't have a script button but it didn't do anything when I pressed CTRL+SHIFT+N.

  • May 6, 2009 at 8:15 am

    #989567

    I found the answer to this and it's to use sp_msx_enlist on the server you want to become the target.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply