Yep, that did it. Inner HASH Join, instead of Inner Join, and the query runs normally. The execution plan is still slightly more convoluted than without the Top clause, but...

• This reply was modified 5 years, 2 months ago by pdanes.

GOT IT!!! Finally - this site had all the necessary details in one place.

https://www.mssqltips.com/sqlservertip/2143/creating-a-sql-server-proxy-account-to-run-xpcmdshell/

If the app gets changes, then an upload is immediately correct. You said that a job doesn't work because it could take a minute to show changes, but those...

If the app loads this, why do you need the dir command? Don't you know where attachments are stored? If you use Filetable, you'll have a known share (\\server\share\path\file)....

1. Filetable is the evolution of filestream that includes a share that is accessible like any other share. https://docs.microsoft.com/en-us/sql/relational-databases/blob/filetables-sql-server?view=sql-server-ver15   FWIW, this doesn't work in many cloud scenarios, so...

I guess I am not following - you still haven't explained why you need to EXECUTE AS.  What is it that requires the procedure to be executed...

• This reply was modified 5 years, 5 months ago by pdanes.
• This reply was modified 5 years, 5 months ago by pdanes.

Two things.

1. Filetable (2012+) solves some of the code hassles of using FileStream. Filestream uses a File I/O access, but not a SMB share.
2. Rather than help a normal...

I guess I am not following - you still haven't explained why you need to EXECUTE AS.  What is it that requires the procedure to be executed in a...

Not really - I have  ONE problem: I don't know what I'm doing.

You stated that compiling the procedure normally - works fine. ...

Not really - I have  ONE problem: I don't know what I'm doing.

You stated that compiling the procedure normally - works fine.  But...

Further to that - if you are using something else...then move the file system stuff to its own procedure and use EXECUTE AS on that procedure.  You can create...

Okay - let's take a step back...can you outline what you need to do with this procedure?  Maybe there is a better way to approach the problem.  This sounds...

I ran the statement (OP):

grant view any definition to [Paleo-Server\SQLServerZaloha]

but the problem persists. What I want is to find the path to the database file on the server,...

Correct me if I'm wrong, please... [Paleo-Server\SQLServerZaloha] is the instance name, correct?  That's not a login.

If, like most people do, the owner of the databases is the disabled "sa"...

Correct me if I'm wrong, please... [Paleo-Server\SQLServerZaloha] is the instance name, correct?  That's not a login.

If, like most people do, the owner of the databases is the disabled "sa"...