|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
27/03/2008, 09h25
|
#1 |
Messages: n/a
Hébergeur: |
Re: SQL Server Log
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 |
|
|
28/03/2008, 22h33
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: SQL Server Log
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 |
|
|
 |
| Outils de la discussion | |
|
|
