Was the server name changed after SQL Server was installed? If so you'll have to do sp_dropserver/sp_addserver to get the new machine name to take effect inside SQL Server.

MSDN reference

Requirement 19 confirmed my suspicions. This is a team lead position. You need to understand and be able to do all these things b/c they expect you to...

So take a full backup of your production database and restore it to a test server. Then let the drives on that machine fill and see if you can...

Thank you Siva. I had seen that KB before I posted but didn't think it applied for 2 reasons. One, I do not have Snapshot Isolation enabled on...

Just recreated the step and confirmed it works by running the SQL Agent job. A couple of things to note:

1) This plan is only being executed on a single...

Markus (10/16/2012)

---

Scott D. Jacobson (10/16/2012)

---

Thank you Markus, I'll try that. I'm also going to try deleting the the plan step and recreate it. I'll report back with the...

Thank you Markus, I'll try that. I'm also going to try deleting the the plan step and recreate it. I'll report back with the results.

You run the same installer but only choose the Management Tools when prompted for which components to install. No database engine, no Integration Services etc. etc.

If you don't have...

You are very welcome. Gald I could be of help.

How about exporting the column to a file using SSIS or the Import/Export Wizard?

Maybe with something like this?

http://www.titus.com/software/sharepoint/index.php

If not to delete them after the fact but, as Gail suggested, keep them from uploading them in the first place.

Providing a link to the BOL page might encourage the rest of us to join in.

The TechNet site is a good place to start. I believe there are several "delete files older than X" type scripts there:

http://gallery.technet.microsoft.com/scriptcenter/site/search?f%5B0%5D.Type=ProgrammingLanguage&f%5B0%5D.Value=PowerShell&f%5B0%5D.Text=PowerShell%5B/url%5D

Do the accounts for SQL Server and SQL Server Agent have permissions to the path you're attempting to delete files in? How are you executing the Maintenance Plan, through a...

Does your Maintenance Plan Cleanup task look like this? Note the lack of a dot (.) in the File extension box. Also, if you're creating directories for each DB,...