SQL Server 2005 Query Error

[stani101]

Please i need help with this. I am quite new to SQL. I am running a query

USE Student
SELECT *
FROM Student

This is the error:

Msg 911, Level 16, State 1, Line 1
Could not locate entry in sysdatabases for database 'Student'. No entry found with that name. Make sure that the name is entered correctly.

The table is there but i keep getting that error.

Please help a novice!

[davash6]

Please i need help with this. I am quite new to SQL. I am running a query

USE Student
SELECT *
FROM Student

This is the error:

Msg 911, Level 16, State 1, Line 1
Could not locate entry in sysdatabases for database 'Student'. No entry found with that name. Make sure that the name is entered correctly.

The table is there but i keep getting that error.

Please help a novice!

Hey this s the correct syntex fro ur code...

USE [Database Name] <-- Here ur databse name only come
select * from [Table name] <-- Here type ur table name ok

[stani101]

Hey this s the correct syntex fro ur code...

USE [Database Name] <-- Here ur databse name only come
select * from [Table name] <-- Here type ur table name ok

hey thank you very much. it works. for a while there i was going out of my head! cheers!