weird problem
-
Then there definitly is an object in master named Test1, what query did you run to try to find it?
-
I used
--------------------
use master
Select Name, XType, user_name(uid) as Owner from dbo.SysObjects where name like '%test1%'
--------------------------
I also tried to create a table called 'abracadabra' (that certainly does not exist) but it failed with the same error message.
-
Follow up
I found out that another process is continuously trying to restore a DB. This is probably causing the weird behaviour.
Thanks for the quick replies.
Peter
-
Are you sure this is the problem??
-
Can it be permission problems?
-
Not sure yet. The DBA is looking into that restore process. Every minute or so it tries to restore a DB. This probably looks some systemtables.
-
Possible... keeps us posted.
-
No permission problem. I asked one of the other adminstrators to create a table in the master DB and it failed as well with the same error.
I'll let you know what caused it.
-
OK, TIA.
-
What SP level is that SQL Server. I think I've seen this before!!!
* Noel -
You've seen too much Noeld...
How long have you been a dba?
-
Longer than I want to admit
* Noel -
So that would be 5 years?
-
-
So the answer would be too long I guess
.
Viewing 15 posts - 16 through 30 (of 47 total)
You must be logged in to reply to this topic. Login to reply