Instead of using cmd exec - use Powershell with the following:

Get-ChildItem C:\SSISFILES\Log | Where {$_.LastWriteTime -lt (Get-Date).AddDays(-5)} | Remove-Item -Force

If you want this to recurse through sub-directories and delete files,...

You don't need to worry about SP3 - just download and install SP4. They are cumulative so you will be fine with that.

The reason you are getting the notice...

Verify the security settings on the share - if the service account does not have full permissions on the folder it won't be able to delete the files.

Follow the article that Brandie linked to. That should get everything you need.

One of the steps of upgrading from 2000 to anything later (2005, 2008, 2008R2, 2012) is to update all statistics. That is a post-upgrade requirement.

If you perform that step...

Stupid question - but did you restart the PC after uninstalling?

If yes, then it seems your uninstall is not completing successfully and the system believes SQL Server is still installed....

It depends on what is being installed - if you don't select anything to be installed from the second disc it won't be used.

Have you verified that everything has been...

That looks like you are trying to restore a backup created on 2008 to a 2005 instance. That cannot be done - you can go from 2005 to 2008,...

jrichards54 (9/5/2012)

---

Jeffery Williams. You posted: The second item I wanted you to do is to go to Programs & Features (Add/Remove), select SQL Server 2005 and the option to add...

You either have corruption in the database - or SAN issues causing problems.

First, run the following (when you can - not during business hours): DBCC CHECKDB ({your database}) WITH no_infomsgs,...

The second item I wanted you to do is to go to Programs & Features (Add/Remove), select SQL Server 2005 and the option to add features.

From here - you should...

Note: SQL Server 2005 needs to be patched before it will work on Windows 7. Find SQL Server 2005 SP4, download it and apply it once you have performed...

It sounds like you were expecting SQL Server to work the same as Access. It does not - there isn't a file you click on to open a database.

SQL...

I would publish the report in an area that is only accessible to my group. Then, I would create linked reports in different folders for each client - or...

Triality (9/3/2012)

---

Thank you for the direction, however none of these examples are applicable. My clients have access to these reports, so I don't want a parameter driving the data...