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 5:42 am

    #1505505

    Roust_m (6/26/2012)

    opc.three (6/25/2012)

    Try it with -Name, like this:

    Get-ChildItem -Name -Exclude dbo.sp_MS*

    This one worked, because it has "dbo."

    Thanks!

    True, but I found it does not work in the rest of the pipeline. I assume this is because the -Name switch changes the output from an object to a simple string, and the .Script method is part of the database object.

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