Setting DBConsole font

[Former Member]

Does anyone know how to set the DBConsole to use a mono-spaced font?

[Former Member]

I may have named dbconsole incorrectly there is only one panel -- it's from the restore of the lightening sysicon for the database engine. I am writing log (debug) messages out using tabs (spacing), etc to align data and the variable font face makes the spacing inconsistent with a monospaced font in an editor when accessing the data from the console log file later.

[former_SQLA_member1694871]

Ahh.... Didn't see this post.

So let me get this straight. You're trying to create a custom log file.

I have NO idea where that font would be set. I'll give it a look and see if I can find anything.

Jeff Gibson

[former_SQLA_member1694868]

Obviously this is not a direct answer to your question, but you could either output the log to a text file with the startup switches on the DB or alternatively write the messages that would go into the log to a text file bypassing the log altogether using string variables and unload selects. You would have much more control over formatting at that point, but you would also have external files to deal with.

[Former Member]

Agree. Especially if you run db server as windows service then there are no GUI console at all. So logfile is a good choice.

[former_SQLA_member1694868]

These are the startup switches to write the log to a file.
Quoting Breck's comment from this question

-o filespec1.txt -oe filespec2.txt -os 1M is a good combination for production. The -os 1M keeps the file size manageable for browsing with Wordpad etcetera. For a service the filespecs probably have to have the full path.

Writing just your messages to an alternate file would be coded by you for each thing that you wanted to track using string variables and then unload select.