Post reply

Unable to find table in the database

  • March 8, 2010 at 12:00 pm

    #212148

    Ok I am executing the following statement

    select * from detail

    and gettign the following error

    Major Error 0x80040E37, Minor Error 0

    > select * from detail

    The specified table does not exist. [ detail ]

    I know the table exists.

    I am using a sdf database file in sql 2005. this was working fine and then suddenly stopped working.

    I am connecting to the databse file from different directories, in some of the directories there were no table.

    Thanks.

  • March 8, 2010 at 12:07 pm

    #1130202

    DISREGARD

  • March 8, 2010 at 12:07 pm

    #1130203

    Are you sure you are in the right database?

    Who is the owner of the object?

    Have you tried this way objectowner.tablename?

    IE :

    select * from dbo.detail

  • March 8, 2010 at 12:09 pm

    #1130205

    dohomebiz (3/8/2010)

    Ok I am executing the following statement

    select * from detail

    and gettign the following error

    Major Error 0x80040E37, Minor Error 0

    > select * from detail

    The specified table does not exist. [ detail ]

    I know the table exists.

    I am using a sdf database file in sql 2005. this was working fine and then suddenly stopped working.

    Are you connecting to the correct database?

    What are you using to run the above query?

    I am connecting to the databse file from different directories, in some of the directories there were no table.

    Thanks.

    One does not typically find a table in a directory. The table resides within the database file not in a directory.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • March 8, 2010 at 12:10 pm

    #1130206

    dohomebiz (3/8/2010)

    DISREGARD

    Does that mean you figured it out?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • March 8, 2010 at 2:58 pm

    #1130310

    I figured it out. thanks for your time.

  • March 8, 2010 at 4:24 pm

    #1130342

    K. Thx

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • March 8, 2010 at 6:55 pm

    #1130370

    dohomebiz (3/8/2010)

    I figured it out. thanks for your time.

    So what was the problem? Might be helpful to other folks if we knew.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

Viewing 8 posts - 1 through 7 (of 7 total)

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