Paul White NZ (7/13/2010)
virgilrucsandescu (7/13/2010)
Weird that it works fine for the other tables in Development DB .. It must be something undocumented ...Possibly the object id returned by OBJECT_ID happens to match a table with an identity column in the context database
Very likely. Object ids are only unique in the context of a database, they are not unique across the entire instance.
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