No problem Uri, will give that a shot.

Thank-you,
Rubens
"Uri Dimant" <urid@iscar.co.il> wrote in message news:%23Pd2EP%23jIHA.1164@TK2MSFTNGP02.phx.gbl...
Rubens

The problem is (sorry for not mentioning that) SQL Server 2005 saves/creates the ERROR.LOG as unicode file, save it as ANSII and run again

"Rubens" <rubensrose@hotmail.com> wrote in message news:eJ0lqo3jIHA.5208@TK2MSFTNGP04.phx.gbl...
Thanks Andrew and Uri.

Uri, this doesn't appear to work with SQL 2005. I tried searching for a bunch of different strings, but it returns null. Any idea?

Thank-you,
Rubens
"Uri Dimant" <urid@iscar.co.il> wrote in message news:OS2sYHyjIHA.2304@TK2MSFTNGP05.phx.gbl...
Rubens
DECLARE @lookfor varchar(25)

Declare @cmd Nvarchar(4000)
set @lookfor = 'SQL'


set @cmd = 'FINDSTR /I /C:"'+@lookfor+'" "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG1"'

exec master..xp_cmdshell @cmd



"Rubens" <rubensrose@hotmail.com> wrote in message news:%239DaWbojIHA.5084@TK2MSFTNGP04.phx.gbl...
Where can I query the SQL Server Log? I'd like to see the Database Mirroring entries using T-SQL, not the log viewer.

Thank-you,
Rubens