Toad World® Forums

Problem accessing to a table


#1

Hi guys i’m connected to a remote database e when in try to see the data inside a table toad says: SQL Server Database Error: Incorrect syntax near the keyword ‘USER’.
Can you help me? I 'm not the creator of the database but i have to work on it
Thanks
Sethlans


#2

Hi Sethlans,

can you please turn on “Execution Trace” in file menu -> Tools
and tell us what exact SQL query is failed.
Many thanks in advance!


#3

This is the output

08/2012 15:41:05: SELECT TOP 1000 * FROM ckarchi_db.dbo.USER Executed on SPID 78:
Statusbar:16/08/2012 15:41:06: SQL Server Database Error: Incorrect syntax near the keyword ‘USER’.


#4

Thanks for details, Sethlans!

I’ve caught the problem - toad doesn’t quote sql keywords (for instance ‘user’) b/c of mistake. The fix should be available in next beta drop (once beta is started).


#5

This still doesnt work in the latest version of toad and for anyone like me who came here googling for a solution, enclosing user in double quotes does the job. e.g.
SELECT TOP 1000 * FROM “USER”


#6

Hi geek4ever,
from what I see this issue is fixed in Toad for SQL Server 5.8 release. Can you please provide any details so we can investigate?