I tried using Greg's script and it works perfectly for my needs on my production server, but when I attempt to run it on my test server, I'm getting a strange error. Both servers are running SQL Server 2005 sp2
Does anyone have any idea what might be causing this?
An error occurred while executing batch. Error message is: The directory name is invalid.