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 3 years 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 3 years 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...

Glad you got it working.

This part of the query is still going to cause problems: WHERE CompleteTaxonText Like '%rupicapra%'

That kind of wild card search can't make use...

Glad you got it working.

This part of the query is still going to cause problems: WHERE CompleteTaxonText Like '%rupicapra%'

That kind of wild card search can't make use...

Glad you got it working.

This part of the query is still going to cause problems: WHERE CompleteTaxonText Like '%rupicapra%'

That kind of wild card search can't make use of statistics...

Glad you got it working.

This part of the query is still going to cause problems: WHERE CompleteTaxonText Like '%rupicapra%'

That kind of wild card search can't make use of statistics...