That's exactly where I'm reading from now - it's right in the quoted Select statement. That is what...

Okay, thanks. I guess  this is one of the pitfalls of using a declarative language instead of a procedural one. I still have trouble getting my head around it sometimes,...

• This reply was modified 1 year, 4 months ago by  pdanes.

That, good Sir, is what I'm talking about being the problem.  That...

In calculated columns in a view, the calculations in columns must be executed to produce the values that can be filtered and only then can the filter be applied...

• This reply was modified 1 year, 4 months ago by  pdanes.
• This reply was modified 1 year, 4 months ago by  pdanes.
• This reply was modified 1 year, 4 months ago by  pdanes.

That did it. I put the view into the FileTable database and changed it around a bit to eliminate Unions. It's massively ugly now, but getting rid of unions and...

If I'm reading all of this correctly, another issue with filtering the calculated columns of a view is that all of the rows must first be materialized and then...

• This reply was modified 1 year, 4 months ago by  pdanes.

Well, I did it with a stored procedure, but it takes some extra dicking around in the app, because it caches the results. I have to do some extra clearing...

The Where clause in the base view is the most complex part of the whole thing. I am looking at various filenames and picking out those I want. Things like...

• This reply was modified 1 year, 4 months ago by  pdanes.

I see. That makes sense, but my source view is rather complicated. The base view picks out all the stuff that is acceptable, and the application is then supposed to...

Okay, thank you. I'll try messing with the permissions until I get it trimmed down to what looks sensible,

Again, NT Service was not an option.It was not offered, and when I typed it in manually,  I got an error message. The account named only Service worked.

So you say...

There was no NT Service, but there is a Service. I gave that full access to the entire D: drive and the system recovered.

But I'm a little fuzzed on such...

It does. As I wrote in the original post, "It throws system error 5, Access denied on any attempt to touch the existing .mdf files." That's right from the log.

What...

Thanks for the kind words. I'm one of those accidental DBAs, and I have a great deal of other work, so I come and go in various forums, as my...

Update - I put a test FileTable into a separate database, backed it up and restored it to a different name. The existing FileTable restored, fully and with no error...