Downgrade an SQL Server from Enterprise to Standard – Disable compression
admin If you got an error about compression, when trying to attach the database from an enterprise version to a standard version. You will have to attach the database to an…
Computer
MSSQL see witch user that have SysAdmins access
WIth this command you can see witch user that have SysAdmins access.
MSSQL Databases
To show all MSSQL databases except the normal system databases.
Remote Desktop seesions – See sessions on all servers in Active directory
If you have enabled that a user get lock out in Active Directory, if the user type the password wrong X times. Then you might have experienced, that yours admin…
Error when trying to remove a Mailbox Database on Exchange Server
When you try to delete a mailbox, you may get this error: This is because the mailbox database still contains data, that need to be moved, before you can deleted…
Problems deleting a old mailbox database
I have a customer, where we have taken over the support from an old supplier, so we don’t know much about their background. The first thing we do, was to…
MSSQL Free Space in Databases files
To get a list of the databases files, and the current disk size in MB, and the Free Space in MB in each fil, you can use this commands If…
Get a list of user and there Group Membership
This is how to get an CSV file, including user_SamAccountName;User_FullName;group1;group2;group3, etc It posible to remove the comment before break, and then break the export after 5 user, to see that…
Powershell: Copy IIS from a time range to a specific folder
I need to search for entry in logfiles between 3/8-2017 and 6/8-2017. So i make this powershell script to prevent search all IIS logfiles. This script will copy all log…
Delete specific mail in Sophus Exim queu
To show the queue in sophus, from CLI type: To delete a specific mail type example: To see how many mails, there are in queue, you can type: