@Jeffrey - I did think about using PowerShell but wanted everything to be in one place.

@jeff - That's very strange.  Yesterday, I refreshed the parent folder quite a...

Guys/gals

Thought I'd resurrect this thread as I've come across a new issue.

I decided to use cmdshell to delete empty folders and ..... it's not going well.

Once a folder is empty,...

The database s on a local server drive (drive S: from memory).

I believe I'm using the 64-bit driver, but I'll need to double-check. I'm guessing the driver is correct because...

Thanks @Brian

I'll agree that the connection being made as the user running the request, but the odd bit is that the SqlServerAgent (which is also running the query)...

Hi all

Firsty,apologies for the late reply.

I think I'm going to leave things alone (just in case).

I've grabbed a workaround for the issue of different drive letters so I think I'm...

Oops, apologies.

Trying again to attach the code.

Hi Jeff

I tested it by using an SSMS window to run the stored procs (which have parameters passed in to them).  That all seemed towork fine.

I've attached the code for...

Hi all

I've come across a weird issue when creating folders using xp_create_subdir.

The folder properties don't appear to be propogating correctly.

I've just tried to access one of the folder to be told...

So I was overthinking it then.

Anyway, I've got the stored procedure working and it enables cmdshell, deletes the folder and disables it again.

Hi Jeff

I think the miscommunication comes from Microsoft themselves (or maybe I've just not read enough into it).  According to this page , it states that there are security...

@jeff -  My understanding was that, once CmdShell was enabled,  is was usable by anyone.  Nice to know that's not the case.

There is a very finite list of people...

Found it.

I'm an idiot and I'd made a syntax error in my VB code.

All now appears to be working as it should.

It's only thrown that error now I've finished my script task (although it didn't throw an error in testing).

I'm passing the path I grab in an earlier item into a...

I've got it sussed out now so I think I'll leave it well enough alone.

I've got an unusual error now that reads:-

Could not find a part of the path 'C:\Program...

Thanks for that.

I origianlly wanted to do it via a stored procedure (to keep everything together, but now I've added a VB script-task to do the same thing.

Thanks agan

Richard