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?

That someone would have to be me. I do get warnings about changes, sometimes, but I don't recall any about dropping relationships. Would it say so specifically, or does it...

Good article - thank you. I read through it and created the table and database trigger as it says. Seems to work just right - I removed one of my...

Here's exactly what I meant by using Paul White's method to grab the first column values only, then using that result set as the source for further processing. The...

I can understand SQL having to scan the table / index, but I don't see why SQL would need to do a sort.  Btw, an asc index will do,...

I can't believe this is so damn difficult. In words, "Read this index, in the order in which it already exists, and return each occurrence of the last values of...

No luck. I've been beating my head against my desk for hours, trying all sorts of correlated subqueries and CTEs.

Most of them don't work at all, and the few that...

I'm looking at that, but it's not going well. I have three columns, not one, and...

Here is the latest index, specifically for this query only.

CREATE NONCLUSTERED INDEX [ix_MaxDruhaEvidence] ON [dbo].[Podrobnosti]
(
[EvidenceLetter] deSC,
[EvidenceNumber] deSC,
[EvidenceExtra] deSC
)

WHERE ([EvidenceLetter]<>'1e')
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB =...