How about using the SQL output format from logparser to import the log data into a database. Assuming that your import from AD contains the SamID then you should...

I do have a database in local containing data from AD, so I was wondering if I can use join, and if I can select directly from log file then...

My mistake, I didn't read your reply carefully.

What's dsquery? How do I use it? it says 'dsquery' is not recognized as an internal or external command.

Hi Thanks for your reply.

I don't understand the 'USING', it's just not working, also, QA reports error in "FROM C:\WINDOWS\system32\LogFiles\W3SVC1\ex080930.log "

I got it, here is the code:

ORDER BY

Case When NextReviewDate < getDate() then '1'

When NextReviewDate >= getDate() And NextReviewDate < getDate() + 30 then '2'

When NextReviewDate >=...

Sorry I didn't quite get you.

The problem seems to be there is no much information has been retained in table sysprocesses, I am just wondering is there any option I...

I checked the sysprocesses (SQL2000), it gives me only four days records, is there any option I should set to make the log longer?

Thanks.

Hi,

Thank you so much for the hint, do you know if there is a way to trigger the sp_who command when somebody access a specific server/database? Although sp_who lists users...

I've tested the syntax of the command I suggested, through xp_cmdshell, and it works.

If the folder name has spaces in it, it needs to be in double-quotes.

You also need to...

DECLARE @CMD VARCHAR (1000)

SET @CMD = 'DIR C:\Inetpub\wwwroot\Pergamum\Doc\*.*'

IF OBJECT_ID('tempdb..#Output') IS NOT NULL

DROP TABLE #Output

CREATE TABLE #Output (CopyResult VARCHAR(500))

INSERT INTO #Output...

thanks all,

the folder EXISTS in the same server of SQL, no problem when I switch to cmd to do the same work.

Thanks for reply.

Your idea is not working.:w00t:

Sorry I didn't describe it clearer:

In my table, every node has its sub tree, so what I would need is to iterate node by node, simply order by any field...

Thank you very much.

Thanks for reply.

Here is my code, there are five classifications: Integrity, Availability, Confidentiality, Contibuity, DBR

CREATE proc spGetClassificationRankingByCode(@code varchar(10))

AS

declare @sysid int

declare @name varchar(50)

declare @rankingtype varchar(50)

declare @ranking varchar(50)

declare @Integrity varchar(50)

declare @Availability varchar(50)

declare...