Re: Can error messages in Query Analyzer be suppressed?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Aaron Bertrand - MVP (aaron_at_TRASHaspfaq.com)
Date: 05/20/04 

Date: Thu, 20 May 2004 17:24:26 -0400

> It works great, but if the table doesn't already exist, I get an annoying
> error message

You can't suppress this. But you can execute your drop statement
conditionally. See http://www.aspfaq.com/2458 (scroll down)

> This code works great if run standalone, but if included in my script, the
> script will always give an error further down at the point where I try to
> create #worktable (saying that it already exists).

If you're just running this in Query Analyzer, you can separate with GO or
just always CREATE #temp tables at the top and DROP them at the bottom. 

-- 
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/

Relevant Pages

  • Re: blue screen
    ... Enquire, plan and execute ... Background information on Stop Error message ...
    (microsoft.public.windowsxp.general)
  • Re: sp_password
    ... SQL Server MVP ... "Leon Parker" wrote in message ... > Whenever I execute the procedure I get the error message that the ...
    (microsoft.public.sqlserver.security)
  • RE: Need Help on Define Names
    ... The error message is "Compile error: ... are in the workbook, execute the rest of code. ... Dim NameMatch As Boolean ...
    (microsoft.public.excel.programming)
  • Re: Removing and event from the html code.
    ... Like I said earlier I inherited this script with the page. ... Actually I don't get an error message, ... > This assigns the *result* of running countdown to window.onload. ... window.onload won't execute until the page has fully loaded. ...
    (comp.lang.javascript)
  • Re: LaTeX2rtf not running
    ... Cannot execute C:\PROGRA~1\LATEX2RTF\LATEX2RT.EXE ... Please cite exactly the complete error message ... probably related to window, not to latex2rtf. ...
    (comp.text.tex)