Permission denied in database ‘TempDB’

Today, opening the Global address book form presented me this nice error: Permission denied in database ‘TempDB’. And this is not the first time this one surfaced, but most of the online solutions are not entirely correct. So let’s explain this one. Doing an online search will show you that the reason of this is […]

SQL Server : Change TempDB location

This is no rocket science but today I needed to move the tempDB to another disk. This is something I though could be done by changing the location path on the database properties in the files tab. Well, bummer, the location was not editable there. So how can we do this… ? Running this query […]