Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

How do I get nice error messages with WISQL32 on NT?

3 posts in Windows NT Last posting was on 1997-11-07 11:19:22.0Z
Operations Posted on 1997-10-31 22:41:37.0Z
From: "Operations" <jamesd@TechWave.com>
Subject: How do I get nice error messages with WISQL32 on NT?
Organization: TechWave
Message-ID: <01bce657$055522a0$1b05000a@jamesd_pc1>
X-Newsreader: Microsoft Internet News 4.70.1161
Newsgroups: sybase.public.sqlserver.nt
Date: Fri, 31 Oct 1997 17:41:37 -0500
Lines: 9
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5438
Article PK: 1081516

When I create bad SQL, I get only the message number. I can look that up
in sysmessages, but the parameters are not substituted in to the string.
It's not as useful as it could be.

This is what the messages look like:
"Server message 207, Severity 16, State 2, Line 1"

Is there some setting to set for pretty messages?

TIA,
James


powersoft Posted on 1997-11-07 11:19:22.0Z
From: "powersoft" <rjxi@public.cz.js.cn>
References: <01bce657$055522a0$1b05000a@jamesd_pc1>
Subject: Re: How do I get nice error messages with WISQL32 on NT?
Date: Fri, 7 Nov 1997 19:19:22 +0800
Lines: 17
X-Newsreader: Microsoft Outlook Express 4.71.1712.3
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Message-ID: <JN4nLV268GA.149@forums.powersoft.com>
Newsgroups: sybase.public.sqlserver.nt
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5430
Article PK: 1081508

select menu "file/option",check "Show SQL Server messages".
if any question,please return to taoyg@public.cz.js.cn

Operations wrote in message <01bce657$055522a0$1b05000a@jamesd_pc1>...
>When I create bad SQL, I get only the message number. I can look that up
>in sysmessages, but the parameters are not substituted in to the string.
>It's not as useful as it could be.
>
>This is what the messages look like:
>"Server message 207, Severity 16, State 2, Line 1"
>
>Is there some setting to set for pretty messages?
>
>TIA,
>James


Opensoft Posted on 1997-11-02 13:23:32.0Z
Message-ID: <345C7ED3.42B483E3@ritsec1.com.eg>
Date: Sun, 02 Nov 1997 15:23:32 +0200
From: OPENsoft <opensoft@ritsec1.com.eg>
Reply-To: opensoft@ritsec1.com.eg
X-Mailer: Mozilla 4.02 [en] (Win95; I)
MIME-Version: 1.0
To: Operations <jamesd@TechWave.com>
Subject: Re: How do I get nice error messages with WISQL32 on NT?
References: <01bce657$055522a0$1b05000a@jamesd_pc1>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 14
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5436
Article PK: 1081514

Howdy James
Have you tried setting "show sql server messages on" from the file menu under
options !!

Ahmed AbdelHady
CSPDBA & CSPPTS

Operations wrote:

> When I create bad SQL, I get only the message number. I can look that up
> in sysmessages, but the parameters are not substituted in to the string.
> It's not as useful as it could be.
>
> This is what the messages look like:
> "Server message 207, Severity 16, State 2, Line 1"
>
> Is there some setting to set for pretty messages?
>
> TIA,
> James