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
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!
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’.
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).
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”
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?