Link to home
Start Free TrialLog in
Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland

asked on

SSMS Query not running

Hi
I am trying to run a simple query in SSMS but am getting the following error

User generated image
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image
try add dbo in front of table name.

like:

select * from dbo.[yourTable]

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of David Johnson, CD
David Johnson, CD
Flag of Canada image
try
select * from [Lesedi].[dbo].Descriptions]

Open in new window

Avatar of Murray Brown
Murray Brown
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

Select * From [dbo].[Descriptions] failed
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image
what if try right click the selected table, and click "Select Top xx rows" ?
Avatar of Murray Brown
Murray Brown
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

Thanks Ryan. Selecting the correct database made all the difference.