if not exists (select * from sysobjects where name = 'YourCompany_PrendiIndirizzo' and xtype = 'P')
begin
declare @procedure as varchar(400)

set @procedure = 'create procedure YourCompany_PrendiIndirizzo as SELECT SettingValue
      FROM HostSettings WHERE SettingName = ''HostEmail'''
execute(@procedure)
end
else
execute YourCompany_PrendiIndirizzo