The code provided was just for explanation purposes. The real one I was using accounted for about ten different variations although I don't think that is still the best way...

I get the reasoning for taking the first 50 characters before the table name but I'm not sure it would accomplish what I want. If I use a charindex in...

I also put something like that together where it would look like this

where ([definition] like '%INTO [tableName]%' or ([definition] like '%update [tableName]%')

That got me the closest I've...

I did come across Pinal Dave's solution but that is different than what I'm trying to do. The solution he lists returns any object dependent on the table whereas I'm...

That is exactly what is happening from a process flow standpoint. However, it succeeds with Windows authenticated accounts so that's why it isn't lining up in my mind.

To add more confusion, it will work if I make AppUser a sysadmin on Server A. However, this isn't an option to keep.

I've dealt a little bit with the double hop issue but this seems to be a little different in the sense it only impacts SQL authenticated users.

The app is passing...

Unfortunately I need to deploy to the file system for this particular project. I think switching from project deployment to package deployment was the missing link I needed. I started...

Giving this another bump to see if there is any general information someone can provide.

I'll delete the proxy and add it back to see if that fixes the issue. It's strange that it's intermittent though

Adding MAXERRORS = 0 to the bulk insert statement causes it to fail which is what I need. Trying to get a meaningful error to display in the catch is...

I've verified all of the appropriate ports are open on the servers so everything looks good there. It seems like the server that cannot make the connection is routing it...

I realize the question is very broad and that is likely due to me not having experience loading transactional data. What I'm getting out of all of the responses is...

That makes sense. What about something like a web form where a new user enters all of their information (name, age, city, state, zip, income, ethnicity, email, etc) for whatever...

No luck with the results to file. Thanks for the help though