0x80070005 Access is Denied

I was creating a scheduled task in Windows XP SP3 and I was getting 0x80070005 Access is Denied error. I looked and tried all I could find in the net. I finally tried the following and it worked!

I made the user local administrator of the machine.

Everything went fine then after.

astu...

Alternating Color for GROUP HEADERS

I am hiding detail row and just showing group header in SSRS and needed alternating color, this is what i used

=IIf (RunningValue (Fields!SomeField.Value, CountDistinct, Nothing) Mod 2 = 0,
"Silver", "White")

it worked !

astu...

Reducing size of MS SQL Server Log File

Couple of days back I realized that my log file has grown out of control. Usually backing up transactions logs and then shrinking the log file should have taken care but I had to take one more step.

I changed the recovery model of the dB from 'Full' to 'Simple' then shrunk the log file and changed the recovery model back to 'Full'. I was able to reduce my .ldf file size from almost 100GB to about 500KB! Quite a resize.

NOTE: Take all cautions while dealing with backend dB. Backups, no users, front end program considerations.

astu. . .