invalid objects
-
i have just started learninf SQL 2000 when i mamakin simplest query in query analyzer select * from authors, where authors is the name of table, its giving error that invalid object ' authors'. how this error can be resolved???
1. check the authors tabls exists in the database 2. check whether you selected / pointed the right database
Regards, Sylvester G sylvester_g_m@yahoo.com
-
i have just started learninf SQL 2000 when i mamakin simplest query in query analyzer select * from authors, where authors is the name of table, its giving error that invalid object ' authors'. how this error can be resolved???
manni_n wrote:
its giving error that invalid object ' authors'. how this error can be resolved???
If you are just learning a better question would be "What does the error mean?" so you can understand what it means in the future. SQL Server has a number of database objects. These include tables, views, stored procedures, functions and so on. You can get a list of all object in the database by typing
SELECT * FROM sysobjectsThe message "invalid object" indicates that the object either does not exist, or it is the wrong type of object for the context in which you are trying to use it. In this case you refer to a table object in the SELECT statement that does not exist (there may be another object in the system called authors, but that will be a different type of object, or be used in a different context.
Upcoming events: * Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ... * Reading: Developer Day 5 Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton My website