SqlDbx Forum

SqlDbx

You are not logged in.

#1 2009-05-21 12:47:09

srouse
Member

Verbose log messages

Connecting to either SQL Server '05 and ASE 15, I don't see anything in the "Messages" tab.

Is there a way to get verbose messaging from the database for the query submitted.
i.e from Whistle ( a very old opensource ASE SQL client)

Thu May 21 11:44:34 2009>> Started
Thu May 21 11:44:45 2009>> Query:
select * from counters
Thu May 21 11:44:45 2009>> Open Client Message:
                        >> Message number: LAYER = (1) ORIGIN = (1)
                        >> SEVERITY = (0) NUMBER = (112)
                        >> Message String: ct_fetch(): user api layer: external error: 15 rows affected.
Thu May 21 11:44:45 2009>> End Query

Thanks,

Scott

Offline

#2 2009-05-21 16:40:45

sqldbxhelp
Administrator

Re: Verbose log messages

Hi, Scott

The messages tab is for messages and errors.
So if there's no messages or errors there will nothing in it.
I am not sure what is the value of seeing all this information.
Are you seeing this message in this other program because there's an
error or it shows it all the time?

Offline

#3 2009-08-20 11:46:57

Teo
Member

Re: Verbose log messages

I think that is a nice feature request. Indeed status bar shows query status like "Query complete:<query>. However if you're running several queries as batch and they are insert/update/delete, it is impossible to see how many rows are affected by each and which of query is completed. It will be good to have as it is valuable information.

Offline

#4 2009-08-20 12:22:35

sqldbxhelp
Administrator

Re: Verbose log messages

Two things you can do now.
1. Switch results from Grid to Text
2. When results set to Grid check "Include messages/errors" on a right click menu

This will not show query text, but maybe it's not a bad idea to add option to do that

Offline

Board footer

Powered by FluxBB