Post reply

Newbie requires help regarding the error message Invalid Object Name

  • December 2, 2004 at 5:23 am

    #102299

    I've just purchased Thearon Willis' book entitled  'Beginning SQL Server 2000'  and have reached chapter 5 (page 146). Which has told me to enter the following select command:-

     

    SELECT Software_Category_ID, Software_Category_VC

                FROM Software_Category_T

                ORDER BY Software_Category_VC

     

    I ran the above command and got the following error message

     

    Server: Msg 208, Level 16, State 1, Line 1 Invalid object name 'dbo.Software_Category_T'.

     

    I have 'googled' the error message but have found no solution yet. In doing this,  I found this site where you guys seem to know what you're talking about. I think my problem might have something to do with either path names (I've prefixed the table name with dbo.) or a security issue.

     

    As you can tell, I am extremely new to SQL Server world and realise that the solution must be  so simple (I hope) that you're almost embarrassed to answer. But please don't be.

     

    I've done everything within the book that has been requested upto page 146 and am seeking assistance so that I can progress to page 147 and beyond. 

     

    I am using the Enterprise edition, my Operating System is Windows XP (SP2) and I have installed SQL Server 2000 (SP3a)

     

    Thank you

  • December 2, 2004 at 6:26 am

    #532174

    I don't know the book, but you're sure you have a table named Software_Category_T in the current db?

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • December 2, 2004 at 10:28 am

    #532253

    Oh my goodness!!!!!

    I can't believe that all I had to do was click on the drop down menu box and change the default MASTER db name to the one that I'm working on.

    I am extremely red-faced with embarrassment but more importantly, grateful, to you Frank for guiding me in the right direction.

    Page 147 here I come

     

     

     

  • December 2, 2004 at 10:30 am

    #532254

    I forgot to say thank you......

    THANK YOU

  • December 3, 2004 at 2:39 am

    #532366

    You're welcome!

    Glad I could help.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

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

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