Home Forums Programming Powershell How to exclude replication stored procedures from a script? RE: How to exclude replication stored procedures from a script?

  • June 26, 2012 at 9:15 am

    #1505641

    $Srv = New-object Microsoft.SqlServer.Management.SMO.Server "Mufasa"

    $Srv.Databases["Abb"].StoredProcedures | where {$_.issystemobject -eq $true} | select name

    This returns 1300+ system procs -- including repls, and I don't have replication enabled.

    P