SQL Server Log

[fatherjack]

Hi,

just recovering from a server crash (OS went nuts, locked completely) and have looked in the SQL Server Logs folder. There arent any clues on the crash but i hit 'export list' and have a text file with the truncated message as viewed via EM rather than the full message as shown if you double click on the individual log entry.

Where are the logs held in SQL Server so that i might try an export via QA to get the full message text?

thanks

PS. SQL Server rolled forward more than 5000 transactions across the server on restart so i am a happy bunny

[MAK]

try

exec master..xp_readerrorlog

[fatherjack]

Cheers Mak