"Incorrect syntax near the keyword" when filtering objects

Toad for SQL Server
1

This has happened to me a lot with SQL Agent jobs when filtering with a keyword, but it may happen in other sections of the object explorer tree. It has also happened across Toad for SQL Server versions, including 5.6 Commercial, 6.1 Trial and 6.1 Commercial.

Any idea what causes this and how to solve it?

ToadError.jpeg
ToadError.jpeg847×401 94.4 KB

2

Nobody’s really seen this? I find it hard to believe, since it’s happened to me across installations of different versions and on different PC’s.

3

Hi rayg73,

I use TOAD SS 6.1 Xpert edition 6.1.0.1759 and I confirm the problem.

I attach a screenshot to confirm the problem.

toad_agent.jpeg
toad_agent.jpeg849×630 111 KB

Best regards,

Sergio

4

Hi rayg73,

I test this problem in the last BETA of TOAD SS 6.5.0.23.

The problem persist and is the some situation.

Best regards,

Sergio

5

Thank you s.bertolotti. This problem has been there for many versions of Toad, just like the object explorer missing a horizontal scroll bar, which has been reported many times.

Now, if Dell/Quest only looked into them…

6

Nothing rayg73.

Have a good day.

Sergio