Hell again,

1.) I typed the following Powershell script in my job step:

$a = Get-ChildItem "E:\Backups\MaintenancePlanReports" -recurse

foreach($x in $a)

{

$y = ((Get-Date) - $x.CreationTime).Days

if ($y -gt 14 -and $x.PsISContainer -ne $True)

{$x.Delete()}

}

2.) I...

I would like to thank each one of you for your replies and suggestions.

No, this is not a test question. We have jobs that are supposed to delete files...

I am sorry, but I could not find enough information on what I am trying to accomplish. Here is what I tried, but without success:

EXEC master..xp_cmdshell 'del C:\file.txt'

Thank you for your reply and for your suggestion.

I will try and see what this suggestion results to.

Thanks again.

I was wondering whether someone could help me with creating a loop to iterate through a table (sys.syslogins) and

change the default databases to a different database for all...

Thank you very much for all those you replied back to my request. I will try your suggestions.

MK