Robert, did you ever get a satisfactory answer to this? I'm getting a new behavior lately where "AS" is moved up to the view declaration line, and my view's first...

Hi Gail, googled right to your post, "hmm, yup, that's what I did." I was hoping it would be a good idea to do the full backup, then immediately...

"cd c:" works! Thanks!!

Finally figured out how to get it working. SQL uses the sqlps utility, which is a Windows PowerShell mini-shell, and it has some restrictions such as mentioned above. ...

Yes, I did the following from a SQL Agent PowerShell job step:

$src = "\\serverpath\filename"

$dst = "e:\path\filename"

Copy-item $src -destination $dst

and still get...

Same problem for me - did you ever get this figured out?