I have another script for gathering information on all servers. Basically I run both against all servers and i have a unique key so the dups fail to enter the...

we put every instance on its own port such as 1433, 2433, 3433 so I dont have that issue, but if I get a chance I may look at it....

no doubt I pull a lot of stuff from a million different places and honestly did not intend this version to get posted. It takes a month to get a...

ok then put "around text to replace"

There are some special characters that this script will not handle because they are valid DOS command operators such as | pipe and > and < etc... but if...

in the servers.txt file you can not have any spaces or it wont read properly, try setting the servername manually and see if that runs.

Every script has value no matter how you slice it. Every time i see a new way of doing something, i like to share it. this script had one purpose...

what is the exact syntax you are using?

you can always enable the command shell and then disable it in the stored procedure. That way its only on for a moment.

@servername is the text you want to change

@newservername is what you want to change it too.

orginanally used to change server name in generated sql files for DR where servername is...

Needs one fix for issue with 2000 in powershell section

change

select TOP(1) line as PSVER from #output

to

select Line as PSVER from #output where line is not null

I have an updated script which works on 2000, 2005 and 2008 as well as 2008R2. It is in the script archive awaiting approval at the momemt. it also works...

and to read a file into a temp table

CREATE TABLE #file (

line varchar(255) null

);

INSERT #file EXEC master..xp_cmdshell 'type c:\downloads\createjobs.sql';

SELECT * FROM #file;

--drop table #file

very simple echo > creates a file echo >> writes to the next line.

declare @filename varchar(300)

declare @sql varchar(200)

declare @sql2 varchar(200)

set @sql = ' echo off...

GO

/****** Object: StoredProcedure [dbo].[DBA_DR_Generate_Script_SQL_Agent_Jobs] Script Date: 12/14/2011 13:34:01 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

/*Requires this run to turn on feature

sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

sp_configure 'Ole Automation Procedures',...