On Thursday, 11 June 2020 19:41:00 UTC+1, Erland Sommarskog  wrote:   
   > Tim Ritberg (tim@server.invalid) writes:   
   > > Am 10.06.20 um 21:56 schrieb Erland Sommarskog:   
   > >> Tim Ritberg (tim@server.invalid) writes:   
   > >>> SA-user solved the problem, but which permissions was missing for normal   
   > >>> user?   
   > >>>   
   > >>   
   > >> Plain users do normally not have permissions in model. You can add users   
   > >> and grant permissions, but it is not a good idea. To wit, when you create   
   > >> a new database, SQL Server copies the files for model. So if you had a   
   > user   
   > >> to model, it will be in every database!   
   > >>   
   > >   
   > > Maybe I could clone settings from local MS SQL EE installation with   
   > > ships with this software.   
   >   
   > Just to clarify: this is "problem" should not be fixed, unless there   
   > is some very special reason. model is a very special database, and it is   
   > very uncommon to run queries against it.   
      
   Perhaps the intention is to run on a user database,   
   and "model" was chosen as an example.   
      
   If I'm following this, the specific statement is   
   looking for the file names in the filesystem that   
   contain the database data, and I wonder why you'd   
   want that from "model", which only exists so that   
   you can say "create database" and make a copy of it,   
   maybe on different filesystems.  You would want to   
   back up model, I suppose.  (People do that for me.  :-)   
   (...I hope.)   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)