Post reply

Why null value for any objectid.

  • September 16, 2009 at 7:04 am

    #135648

    I am getting null value for following object and many other objects as well (Not for all). The object resides at Adventureworks database.

    select object_id('person.document')

    Can anyone tell me why this is happening 🙁

    -LK

  • September 16, 2009 at 7:14 am

    #1054406

    Make sure you are running you statement against the right database.

    Use this statement:

    USE Adventureworks

    GO

    select object_id('person.document')

  • September 16, 2009 at 7:20 am

    #1054411

    luckysql.kinda (9/16/2009)

    I am getting null value for following object and many other objects as well (Not for all). The object resides at Adventureworks database.

    select object_id('person.document')

    Can anyone tell me why this is happening 🙁

    -LK

    I think you have the wrong schema! The only Document table I can find belongs to the Production schema, not Person.

    SELECT OBJECT_ID(N'AdventureWorks.Production.Document')

  • September 16, 2009 at 7:48 am

    #1054436

    My bad.

    It means object id can never be null.

  • September 16, 2009 at 8:06 am

    #1054456

    Correct - you should not have a null value for the object id unless you're in the wrong database or have a typo in the schema/object.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply