SQL Server - Lanzar scripts sql hacia multiples SQL DBs

declare @Nodes Varchar(100)

set @Nodes=''

 if (SERVERPROPERTY('IsClustered') = 1)

begin

select @Nodes=@Nodes+ NodeName

+',' from sys.dm_os_cluster_nodes order by NodeName

set @Nodes=substring(@Nodes,0,LEN(@Nodes))

select

@Nodes as HostName,

SQLInstanceName = @@SERVERNAME,

'Yes' as IsClustered,

CAST(SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS VARCHAR(50)) As ActiveNode,

SERVERPROPERTY('edition') As SQLEdition,

Case

  when cast(serverproperty('productversion') as varchar) like '8.%' then 'SQL2000'

       when cast(serverproperty('productversion') as varchar) like '9.%' then 'SQL2005'

       when cast(serverproperty('productversion') as varchar)  like '10.0%' then 'SQL2008'

       when cast(serverproperty('productversion') as varchar)  like '10.50.%' then 'SQL2008R2'

       when cast(serverproperty('productversion') as varchar)  like '11.%' then 'SQL2012'

  when cast(serverproperty('productversion') as varchar)  like '12.%' then 'SQL2014'

       ELSE 'SQL7.0' END +' '+

  cast(SERVERPROPERTY('productlevel') as varchar(50))+' ('+ cast(SERVERPROPERTY('productversion') as varchar(50)) + ')' as SQLVersion

end

 else

begin

select @Nodes=CAST(SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS VARCHAR(50))

select

@Nodes as HostName,

SQLInstanceName = @@SERVERNAME,

'No' as IsClustered,

SERVERPROPERTY('edition') As SQLEdition,

Case

  when cast(serverproperty('productversion') as varchar) like '8.%' then 'SQL2000'

       when cast(serverproperty('productversion') as varchar) like '9.%' then 'SQL2005'

       when cast(serverproperty('productversion') as varchar)  like '10.0%' then 'SQL2008'

       when cast(serverproperty('productversion') as varchar)  like '10.50.%' then 'SQL2008R2'

       when cast(serverproperty('productversion') as varchar)  like '11.%' then 'SQL2012'

  when cast(serverproperty('productversion') as varchar)  like '12.%' then 'SQL2014'

       ELSE 'SQL7.0' END +' '+

  cast(SERVERPROPERTY('productlevel') as varchar(50))+' ('+ cast(SERVERPROPERTY('productversion') as varchar(50)) + ')' as SQLVersion

end  

##Save the below powershell script in folder "D:\ExecScriptOnMultiServer\ExecuteQueryOnMultiServers.ps1"

$QueryPath= "D:\ExecScriptOnMultiServer\SQLQuery.sql"

$OutputFile = "D:\ExecScriptOnMultiServer\QueryOutput.txt"

$ExecuteQuery= Get-Content -path $QueryPath | out-string

"Results -- > `r`n`r`n" > $OutputFile

FOREACH($server in GC "D:\ExecScriptOnMultiServer\ServerList.txt")

 {

	$server

	"---------------------------------------------------------------------------------------------------------" >> $OutputFile

	$server >> $OutputFile

	"---------------------------------------------------------------------------------------------------------" >> $OutputFile

	invoke-sqlcmd -ServerInstance $server -query $ExecuteQuery -querytimeout 65534 | ft -autosize | out-string -width 4096 >> $OutputFile

 }