See if a database is using Enterprise features of an Microsoft SQL server.
admin Run this command to see if any database on the SQL Server is using enterprise features
2018
Downgrade an SQL Server from Enterprise to Standard – Disable compression
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…
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…