Hi,

Thanks for your post.

The length of the Find string will always be the same length as the Replace string, we can't turn the triggers off. 

Is there a simple way...

Sorry, the script to insert data into the table should have read ...

INSERT INTO MyTable

VALUES ('EXEC sp_FindReplace', 'ServerName1', 'ServerName2')

The table that contains the data is ...

CREATE TABLE [dbo].[MyTable] (

 [Statement] [varchar] (100) COLLATE Latin1_General_CI_AS NULL ,

 [ServerName] [varchar] (30) COLLATE Latin1_General_CI_AS NULL ,

 [ReplaceValue] [varchar] (30) COLLATE Latin1_General_CI_AS NULL

) ON...

Hi,

Do you know where I can find out how to execute the statement below using xp_execresultset?  The code below basically creates a string that contains

exec sp_Myprocedure 'param1', 'param2'

How can...

Hi,

Thanks for that.  The example works but when I change it to reference my tables it falls over.

As the data volumes will be very small (less than 50 rows) is...