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 7:55 am

    #1505580

    schleep (6/26/2012)

    This will exclude all non-user objects. I assume they're probably not required anyway.

    Get-ChildItem | where {$_.IsSystemObject -eq $false}

    That brings up a good point. I have replication enabled in my DB and see the repl procs under System Stored Procedures in SSMS but when I run just Get-ChildItem (i.e. without any filtering) at the StoredProcedures prompt in PS none of the repl procs are returned, in fact no system procs are returned, I only see my user-defined stored procedures.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato