How to retrieve the path of errorlog?

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Antares686 SSC Guru Points: 125444 More actions · Answer 1

As I recall it is in the registry not in SQL Server.

Greg Charles SSC-Forever Points: 45403 More actions · Answer 2

If you open an error log in Enterprise Manager, you'll see a message at startup that says, 'Logging SQL Server messages in file filepath'.

Greg

SQL ORACLE One Orange Chip Points: 27807 More actions · Answer 3

I would like to retrieve this info by a script. Any input?

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 4

It's a parameter in the service startup, so it should be in the registry. You can get it from xp_regread or any registry scripting