January 9, 2004 at 11:53 am
We are using Sql server 2000. We had the following problem.
We Were unable to access the Database which resides
in System A. We are able to enter into Query analyzer in sql server
Authentication using username:xyz and the Password. After Sql Server
Authentication we were not able to access the Object. we have Owner as
xyz. So when we gave a query to access the Table as “select * from
Table_1”. It gave an error 'invalid Object Name'. But we can access the object as “select * from xyz.Table_1”.
While Checking the log for error it shows 'Block lock Allocation error' at 9 pm. we were accessing the database till 9 pm and we
shutdown the system around 9.30 pm. We noticed the problem in database on the next day morning only .
we restored the database to another system B using recent Backup file
from System A. After Taking a Complete Backup We deleted the database from System A and restored from Backup file. After that System A database is working fine.
We are not Clear what caused this Problem.
I appreciate if any one could give us the reason and severity of this Problem so that we can avoid such problems in future. Thanks in advance.
Shan
January 9, 2004 at 12:58 pm
Run DBCC CHECKDB to your database.
January 9, 2004 at 2:54 pm
and for the select, if the owner is "dbo" then the parser automatically resolves this. If any other user owns the object, you must query as owner.object.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply