If it is same server, it is good to use TSQL as Eric suggested. If it across servers, you can even use a data flow to leverage the SSIS pipeline...

What do you mean when you run the rebuild in local? Do you have a copy of the same database in your developer workstation/ laptop?

If that is the case...

Delete uses exclusive locks. Definitely tuning your where clause will help.

The dynamic SQL may give you a tough time though.

First, stop having negative thoughts, that will only harm you!

As Jeff pointed out, with a clear head, list out few things that you can work on and take some action.

Read...

Yes. And if at all there are more possible...

Yup. Filestream supports only window authentication. But there is a workaround though.

http://www.sqlskills.com/blogs/bobb/using-filestream-streaming-io-and-sql-logins-with-impersonation/

John Mitchell-245523 (6/3/2016)

---

I think that's about as concise as you're going to get it. As you'll have noticed, string manipulation isn't one of T-SQL's strengths. If you're going...

I cant find anything wrong in the function assuming you are using this in your catch block. How are you handling the catch for this insert. Are you getting any...

It is the name of the sheet in the excel, example if you have multiple sheets, each one of them can be accessed as a table individually.

From your first reply it looks like shared memory is not enabled. For connections connecting locally, SQL server must be using shared memory protocol. Have you tried enabling this?

I think this clearly says the cant see the...

1) Are you able to access the database instance from a remote SSMS ?

2) Are you using any aliases in the SQL Agent Properties-Connection?

Is the browser service running?

Have you tried running the SQL Profiler?

Nice, catch, edited and added group by if at all OP is interested still.