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

Got it - I was missing an index for AkcesAutoID on the Podrobnosti table. Adding that makes it run properly.

Extremely important thing to remember:

A common table expression (CTE) is not a table. It is an expression. A query. It does not, in any way, represent data storage, temporary...

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

1. Yes:>

-----------------------------------------------------

CREATE TABLE [dbo].[Akces](

[AkcesAutoID] [int] IDENTITY(1,1) NOT NULL,

[Rok] [smallint] NOT NULL,

[AkcesitPred] [varchar](5) NOT NULL,

[Akcesit] [int] NOT NULL,

[KusuVKatalogu] [int] NULL,

[Petrol] [bit] NULL,

[BezPoctuKusu] [bit] NULL,

[Jine] [bit] NULL,

[UzOdepsane] [bit] NULL,

[VDatabaziMK] [bit] NULL,

[Poznamka] [nvarchar](4000)...

Sorry, guess I wasn't completely clear. Space is not a consideration - I have 3 TB  of disk space on the machine and less than 1 TB used. The database...

I've started looking at designing a system of mutual controls, set up on numerous systems, which would periodically interrogate each other and report to a central point when one of...

Last re-start was just about a week ago. When and how many before that I don't know, but as I wrote earlier, this machine restarts occasionally for no reason that...

Around two weeks ago - I don't recall exactly and I'm not at work right now. I'll check. There are also sporadic seeming power failures in this machine, and I...