Thanks Scratt, that's exactly what I had in mind. Nice work and thanks to the original author too.

I like the script but it is unfortunate that it doesn't pick up the schema name too, anything other than dbo results in "Cannot find the object because it does...

I had a look on connect just to see and it has been requested in the past mainly for reasons around TDE and collation but it was a no anyway.

Not sure but it sounds like it could be inheritance, can you see that the sub-folder took the same permissions as its parent?

Eric M Russell (10/12/2015)

---

Temporary tables, spools, hashes, etc. are not tied to any specific database. For example, assuming we wanted to have a separate temporary work area for each databases,...

I would say to definitely ask here first if you have any doubts. In my opinion you should prioritise learning about backup and restore, particularly checking that you actually have...

I think there are plenty of people that would be happy to see multiple tempdb databases but Microsoft have never added this.

If you are seeing tempdb contention this can...