Question froma Newbie...
I am writing my first project with an MSDE database.
I do not have available Microsoft SQL Server Tools such as Query Analyzer.
A SQL query returns an error in line 97.
My questions are:
1. Does anyone know of any (free) tools like Query Analyzer that will debug my query, highlighting the code with error.
2. Failing that how can I work out what is the true 97th line of code in my query. The 97th line of code is a blank.
Thanks in advance.
I am writing my first project with an MSDE database.
I do not have available Microsoft SQL Server Tools such as Query Analyzer.
A SQL query returns an error in line 97.
My questions are:
1. Does anyone know of any (free) tools like Query Analyzer that will debug my query, highlighting the code with error.
2. Failing that how can I work out what is the true 97th line of code in my query. The 97th line of code is a blank.
Thanks in advance.