Rechana Rajan (12/7/2016)
As per my understanding for this user it will check the [bill] schema first and then dbo and it wont go any further. Please correct if I am wrong.
No, it will check the default Schema only. If that default is [bill] then it will check for [bill].[tablename]. If [bill].[tablename] does not exist, then the failure occurs.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk