We rolled out own data obfuscator program. Whenever the prod DB was restored to a new environment we used a function to alter letters and numbers of sensitive data fields...

BCP is fabulous because it's fast. One undocumented, and altogether nifty little "feature" is that you cannot count on BCP to maintain the original order of the data in the...

Another nifty difference between Fn and SP  is table variables. You can't pass table variables into stored procs - *darnit* - but you *can* call a function that returns a table...

I'm assuming the "Be Made using the login's current security context" option is what's breaking? Make sure the domain account you are using is in the local Admin group on both...