Home Forums Programming Powershell Need a way to script out LinkedServers on a SQL 2005\2008 boxes but place the script in seperate files. RE: Need a way to script out LinkedServers on a SQL 2005\2008 boxes but place the script in seperate files.

  • January 27, 2012 at 11:49 am

    #1439554

    This worked for me:

    Add-PSSnapin SqlServerCmdletSnapin100 -ErrorAction SilentlyContinue

    Add-PSSnapin SqlServerProviderSnapin100 -ErrorAction SilentlyContinue

    [System.Reflection.Assembly]::LoadWithPartialName(‘Microsoft.SqlServer.Smo’) | Out-Null

    foreach($linkedServer in (Get-ChildItem SQLSERVER:\SQL\MYSERVER\DEFAULT\LinkedServers)) {

    $linkedServer.Script() | Out-File ("C:\LinkedServer." + $linkedServer.Name.Replace(".","_").Replace("\","$") + ".sql")

    }

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