Post reply

what is the formula to get the table given hex figure..

  • February 14, 2007 at 10:19 am

    #116127

    Hi all

    I have this hex 0x4319E038 pertaining to a table, after converting to int, i couldnt not find this particular ID in sysobjects...

    What is the formula to get the particular table given this hex figure?

  • February 14, 2007 at 11:29 am

    #689785

    you should be able to use the object_name function without translating to decimal:

    select object_name(0x4319E038)

    select object_name(0x60FC61CA)

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • February 15, 2007 at 9:08 am

    #689995

    Don't forget to set your database context to the proper database prior to running the select. If you do not, then you can get an incorrect object name or NULL as a result.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 3 posts - 1 through 2 (of 2 total)

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