Database is MSSQL 2008.
The site is getting 500 internal error.While checking the logs it says object doesnt exists.
In the asp code, it was like dbo.testusernew.tablename1
and in db it looks like dbo.testuserold.tablename1
So i goahead and alter the schema ,also for one of the view in the select clause i make the changes as below
(select dbo.testuserold.tablename1 to select dbo.testusernew.tablename1) .
It worked fine after that .
Well , now the problem is again i got the error only on that VIEW .So i checked the db again.
The tables looks like dbo.tablename1 instead of dbo.testusernew.tablename1
( still it works fine not throwing any error)
In the view i changed as below and then it worked fine.
My question is how it was automatically changed from dbo.schema.tablename to dbo.tablename ?
(select dbo.testusernew.tablename1 to select dbo.tablename1)
Any ideas , curious to understand it.