SSMS Query not running

Murray Brown
Murray Brown used Ask the Experts™
on
Hi
I am trying to run a simple query in SSMS but am getting the following error

1
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Ryan ChongSoftware Team Lead

Commented:
try add dbo in front of table name.

like:

select * from dbo.[yourTable]

Open in new window

Software Team Lead
Commented:
and make sure you select the correct database instead of the default "Master"
Top Expert 2016

Commented:
try
select * from [Lesedi].[dbo].Descriptions]

Open in new window

Murray BrownASP.net/VBA/VSTO Developer

Author

Commented:
Select * From [dbo].[Descriptions] failed
Murray BrownASP.net/VBA/VSTO Developer

Author

Commented:
Ryan ChongSoftware Team Lead

Commented:
what if try right click the selected table, and click "Select Top xx rows" ?
Murray BrownASP.net/VBA/VSTO Developer

Author

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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial