1

Topic: exec xp_cmdshell ' type C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG'

The people;
Help to read file contents
exec C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG
With the help:
xp_cmdshell ' type C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG'
All tried.
xp_cmdshell ' type "C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG"'
xp_cmdshell ' type [C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG]'
an error
Syntactic error in file name, folder name or a volume label.
The server remote, access  ...
SQL 2000
All thanks.
It is necessary urgently...

2

Re: exec xp_cmdshell ' type C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG'

For this purpose is xp_readerrorlog.

3

Re: exec xp_cmdshell ' type C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG'

Gavrilenko Sergey Alekseevich;
UNION OF RIGHT FORCES...

4

Re: exec xp_cmdshell ' type C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG'

Sergey Alekseevich wrote:

For this purpose is xp_readerrorlog.

REALLY TO SEE WHO OR WHEN MADE DELETE OR TRUNCATE?

5

Re: exec xp_cmdshell ' type C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG'

Valerii wrote:

it is passed...
REALLY to SEE WHO OR WHEN MADE DELETE OR TRUNCATE?

it is real. Only for this purpose it was necessary to adjust audit to DELETE OR TRUNCATE.

6

Re: exec xp_cmdshell ' type C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG'

Sergey Alekseevich wrote:

it is passed...
Really. Only for this purpose it was necessary to adjust audit to DELETE OR TRUNCATE.

The built in means are triggers or?

7

Re: exec xp_cmdshell ' type C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG'

Valerii;
In your case it .