Thanks for all of your reply, as few people replied that try logging in with the service account and then change the date format. That worked, as the date time...

Tried running the SQL Under Local system account as well no luck

I suspected the same but I did disabled the Cleanup agent job and observed the both LogReader agents block eachother.

Stoped 1 log reader and observed enabling AgentClean up job and...

Thanks nimdil for the query as well for the time...

Nimdil the query is good but the thing is it is deleting both the duplicate rows whereas we need to get...

The above thing dosent work as it has 2 values for each node and i need to read all the 2 values

any luck from any 1

Well its so strange that we cant keep a track who did what on yesterday as i said i am not suppose to have a trigger .....

Thanks for all...

My question is i need to track a user activity which was done in past (Yesterday) and i dont want put any trigger or so...

This is somewhat similar to your requirement it also kills the bad session ....

Just set it accordingly to fit your requirement.

DECLARE @spid int

DECLARE @sqlStr nvarchar(255)

DECLARE @DBCC VARCHAR(100)

SELECT @spid=spid FROM sysprocesses...

its a SAN Drive and I also moved Log file from Y:\ But still the issue persist and the thing which bother's me is how i am getting Report Server...

Thanks for the reply

Well its our Prod Server and I always keep my tempdb seprate from other db's so except tempdb on Y:\ I have nothing on it and I...

Hey Damon

Thanks for your reply and i appreciate your time and i did liked your code anyways my lead wants me to remove all the cursors use something else instead...

hi mr polecat

i really appreciate your time basically your are right and good that you understood what they want

and i know its weird that they want like this am...