Two thoughts.  First, does:

EXEC SP_who2

give you any results for a user connected to the database test1?  If there are a lot of connections, it can be a...

Happy to help.

I didn't cover EVERY scenario, I just covered some.  For example, if you have an IP allowed list and ONLY a small set of IP addresses are allowed...

The actual rule we have in place isn't specific to single character aliases though.  Our rule is that aliases and variable names must be specific enough to identify the object....

Since you have all the hard work done, all that's left is to put the table names in and define how you want to join them.  Since you have a...

I think this post will tell you how to do it:

https://stackoverflow.com/questions/49741600/database-stuck-in-a-single-user-mode-in-sql-server

To paraphrase, run

SELECT spid
FROM master..sysprocesses 
WHERE spid > 50 AND dbid = DB_ID('<Your_DB_Name>')

and kill that SPID.

To add to what Pietlinden said, we also have no visibility into that function.  You MAY be able to tune the function.

As far as I know, using a table valued...

I am not sure why you marked the previous answer as spam when it (as you said) answered your "initial question" but was not what you were expecting.

If you followed...

I'd probably start by writing it in a manner that is easier to see and read (my preference, not required).  So something like:

  WHERE 
 ...

If the database names and table names are static and not going to change (ie no new ones coming in and none going away), then I'd recommend hard-coding it all...

Happy to help.

Also, thanks for the follow-up!  It is always nice to hear if a solution helped or not and what the final solution ended up being.

First step would be to tell us the error as the error likely says how to fix it.

My GUESS is that you are getting a "invalid column name" error which...

Ok, I just misread the error.

If you import into memory (ie have no output step on the Excel import), do you still get the same error?

I am just thinking MAYBE...

Figured this out for you:

https://data-dev.blogspot.com/2017/03/ssis-export-data-to-excel-with-more.html

It is a limitation of the SSIS Export to Excel that 255 characters is the max.  The workaround was to export to a flat file (txt,...

My opinion - you should implement any security based things that you require.  Sounds like a dumb response, but think about it from a hacker perspective.  If a hacker gets...

I think the RTFM type responses, when written properly, can be just as helpful as asking the right questions.

I mean, if your response is "RTFM" and nothing more, then I...