April 7, 2008 at 10:22 am
This happened in SQL 2000 yesterday, for no apparent reason. Unfortunately could not get all details before that dba did a DROP TABLE which got rid of both entries.
Trying to run a CREATE TABLE statement got error something like `table name already exists`. Viewing via Enterprise Manager showed single table, but ...
SELECT name FROM sysobjects WHERE name='x'
-- got 2 rows
How can that happen?!?
April 7, 2008 at 1:40 pm
Different owners?
Someone messing with Allow Updates?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 7, 2008 at 5:43 pm
Different owners a possibility. How would I find out if that situation exists?
April 7, 2008 at 11:49 pm
In sysobjects, the uid column will be different. You can join to sysusers to get the name of the table owner
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply