right, so local system does not have domain access to any network shares, for example. it cannot browse to \\machinename\d$\somefolder.

to do that, you...

take a look at this thread:

http://www.sqlservercentral.com/Forums/Topic1707571-3411-1.aspx#bm1707577

typically, the fix is to explicitly assign master as the default database, and then cleanup the default db from there.

the thread mentions issues that contribute,...

just like xp_cmdshell, the service account that SQL is using is the credentials used for accessing objects outside of SQL server.

if your process was accessing local folders , special folders...

Jason i know i inherited a ton of servers, where noone was still around to add users as sys admin, or there was no admin at all.

I've got several scripts(powershell,...

i took this post as an attempt to use a third party security audit solution that either has limited scope, or you might have limited experience with it.

it's...

Sean Lange (8/7/2015)

---

I was fiddling with a version of my own using that same function when Luis posted his. I scrapped mine immediately as I saw the approach he was...

just for reference, this is how i tried to solve it;

i parsed everything with DelimitedSplit8K, and then just fiddled with columns that were larger than the target length.

my sample...

ahh, better than what i was trying next, Luis!

i started splitting the all data on CHAR(10), and then splitting whatever had a length that was over @MaxLength ;

i like...

when modified to your example, that's exactly what it does:

/*--results:

TheObjectNameLineNumberLine

Some Comments1ENSURE THE PRODUCT CODE AND BATCH INFORMATION ON

Some Comments2ROUTE CARD IS CORRECT AGAINST THE PICK SHEET &

Some Comments3LABEL

*/

--http://www.sqlservercentral.com/Forums/Topic677895-338-1.aspx

DECLARE @MaxLength int...

Sean pinged me on this one, and i've posted versions of it elsewhere, but i have code saved from other members posts, so let me point you to them.

Lowell (11/13/2013)

---

take...

if Dts.Variables["User::V_FileExistsFlg"].Value is a boolean, you should assign true or false, and not 1, right?

Also,if you append strings like that together, you have to be absolutely sure of ending slashes,...

damnit i was looking for you!

based on some of your comments, i suspected you might be local,...

well, i don't consider TFS to be highly volatile, the developers might have what, a hundred or so check-ins a day?

so this is my default setup for backups:

ALL TFS...

i can tell you how my TFS is setup, and I've had no problems. use that to help make a more informed decision.

my TFS is on a single virtual server...

Jo i use a script task to pull that out for other script tasks to consume all the time..

here's a full script task example, but the piece you need is...