CREATE TABLE txtSearch_Stage([Data] varchar(max))
CREATE TABLE txtSearch([Row_ID] int IDENTITY(1,1),[Filename] varchar(256), [Data] varchar(max))
GO

TRUNCATE TABLE txtSearch_Stage

BULK INSERT txtSearch_Stage FROM 'D:\SPROC_EXEC_XML.SQL'
	WITH (
			DATAFILETYPE = 'widechar'
		 )
GO

INSERT INTO txtSearch ([FileName], [Data])
SELECT 'D:\SPROC_EXEC_XML.SQL', [Data] 
  FROM txtSearch_Stage

SELECT * FROM txtSearch
WHERE [Data] Like '%e%'
GO

DROP TABLE txtSearch, txtSearch_Stage
GO