Outlook error - You don't have appropriate permission to perform this operation.

If you upgraded outlook to a newer version, maybe you are going to get a problem that you cannot move any mails to personal folder with the error:
"Cannot move the items. You don't have appropriate permission to perform this operation."

The error is because most likely the value of the key pstdisablegrow needs to be changed to allow the pst file to be changed.

To solve the problem:

• Open the regedit to modify the outlook registry.
• Locate the following registry key: HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Outlook\pst

• Double click on the Dword pstdisablegrow and change the value from 1 to 0

That should fix the problem.

Error trying to attach a SQL database: CREATE FILE encountered operating system error 5(failed to retrieve text for this error. Reason: 15105)

If you are trying to attach a database using SQL management studio and you get the next error:

CREATE FILE encountered operating system error 5(failed to retrieve text for this error. Reason: 15105) while attempting to open or create the physical file

It is because you are not running management studio as an administrator and the account you are using doesn't have the rights to open the database file.

To solve this problem, right click on the SQL management studio shortcut and select:

Run as Administrator

That will let you attach the database.

SQL database stuck going offline

If you are trying to take a database offline and it got stuck, looks like it is not accessible anymore, but it’s not quite offline, you need to kill all the processes related with that Database.

With the next command, see all the processes running and look for the ones related with the database:

EXEC sp_who2

Get each SPID with the DBName database you want to take offline, the use the next command to kill each process

KILL <SPID>

This should solve your problem.