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

    #1505677

    From the OP's code, modified for my machine for demo:

    Add-PSSnapin SqlServerCmdletSnapin100 -ErrorAction SilentlyContinue

    Add-PSSnapin SqlServerProviderSnapin100 -ErrorAction SilentlyContinue

    Set-Location SQLSERVER:\SQL\MyComputer\MyInstanceName\Databases\MyDataseName\StoredProcedures

    Get-ChildItem | Select Name

    I only receive a list of user-defined procs.

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