i have created a temp table using tempdb..test_rep using some test user. but when i login as sa it is giving the error message saying that object not found. but when query the sysobjects table for the same name it is showing.
I am able to see when i log out and login through test user. but for sa user only it is not showing.
Can any one reply for this issue?
I tested this in UAT server it works fine but on production box it is not.