Posted by David Portas on 09/07/06 21:11

johnivey@gmail.com wrote:
> I have a large query that I am trying to debug in query analyzer.
> However, the errors I get have no line number or reference to where
> they are failing. How can I find out what line in the query is causing
> a particular error message to appear?
>
> Thanks
> John Ivey
> South Pike School District

What is the error message?

Try simplifying the query until it works. Exactly where to start
depends on just what the error message is.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

• Next in forum: Re: transaction inside sp_executesql
• Prev in forum: Re: Creating a dynamic Global Temp Table within a stored procedure
• Thread view: Re: Finding a line number

[Reply to this message]