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 4 years, 7 months ago by pdanes.
• This reply was modified 4 years, 7 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"...

See this link: https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-master-files-transact-sql?view=sql-server-ver15

The login would need VIEW ANY DEFINITION to see anything in sys.master_files AND access to the database(s).  If the login does not have access to the...

Really? Not one person even has an idea?