Viewing 6 posts - 1 through 6 (of 6 total)
Just as an addendum; Sql Server 2016 SqlPS FINALLY doesn't switch up the provider anymore (and loads tons faster to boot...), so hopefully this thread won't be useful anymore...
S
June 9, 2016 at 12:27 pm
No problem. This is apparently the most helpful thing I've ever done on the internets. 😉
Scott
June 11, 2015 at 11:55 am
More than likely. I've just gotten into the habit of just calling powershell directly in a cmd line from the job server instead of putting it into a powershell...
July 28, 2013 at 9:05 am
You need to change the provider when the job runs. It's running under the sqlserver:/ provider. Just do a cd c: at the top of your script and...
September 5, 2012 at 1:19 pm
I'm experiencing the same issues as well. My tables do not contain any large data types either. The table has only two rows and both are of type...
January 4, 2010 at 11:59 am
Viewing 6 posts - 1 through 6 (of 6 total)