Forum Replies Created

Viewing 3 posts - 46 through 48 (of 48 total)

  • RE: Replication Monitoring using t-sql

    here is one way:

    each replication agent will have one job to start it, if the job stops or fails to start for whatever reason, you can query through msdb..sysjobs union...

  • RE: Deleting redundant Subscriptions

    Use sp_dropsubscription so you don't have to browse EM, below is the minimum permission needed to execute the command.

    from BOL:

    Permissions

    Only members of the sysadmin fixed server role or db_owner fixed...

  • RE: Run VB exe file via xp_cmdShell

    hi i tried, this.

    i'm trying to start the winvnc.exe installed on one server in a sql job packaged inside another vb exe file. The job started the exe file but...

Viewing 3 posts - 46 through 48 (of 48 total)