set xact_abort on

declare @currval nvarchar(500)
declare @newval nvarchar(500)
declare @search nvarchar(500)
declare @replace nvarchar(500)

set @search = '/Index.aspx' --string to find
set @replace = '/Default.aspx' --replacement string

declare @pos int
declare @id bigint

begin tran

declare curs cursor local fast_forward
for
	select template_id,template_filename
	from templates_tbl
	where template_filename like '%' + @search +'%'
open curs
fetch next from curs into @id, @currval
while @@fetch_status = 0
begin
	print 'Url before update=' + @currval
	Set @newval = replace(@currval,@search,@replace)

	Update templates_tbl Set template_filename = @newval
	where template_id = @id

	print 'Value after update=' + @newval

	fetch next from curs into @id, @currval
end

close curs
deallocate curs

rollback tran
--commit tran