Toad World® Forums

"Incorrect syntax near the keyword" when filtering objects

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?

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.

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.

Best regards,

Sergio

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

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…

Nothing rayg73.

Have a good day.

Sergio