Data base problam in SQL server 2005

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER Proc [dbo].[Sp_GetCompanyAddressNew]
@ContactTypeId as numeric(9)
as
begin
select distinct isnull(convert(varchar,Address1),'')+' '+isnull(convert(varchar,Address2),'')+' '+isnull(convert(varchar,Address3),'')+'*'
+isnull(convert(varchar,city.Name),'')+'-'+convert(varchar,PinCode)+'*'
+isnull(convert(varchar,state.Name),'')+','+convert(varchar,Country.Name) as address
from TblsubCompanyAddress SVA
Left outer join TblAddressBook City on SVA.City=city.AddressID
Left outer join TblAddressBook State on SVA.State=state.AddressID
Left outer join TblAddressBook Country on SVA.Country=Country.AddressID
where SVA.AddTypeId= @ContactTypeId
end
This is store procedure in in two database object Impact and Impact2 when we run this inside the impact this is working but when we run inside Impact2 this is not working this is return null values but both database table is same ......
Please give me solution