You can go into the situation that after installation of MSSQL Server you found that you forgot to set colation to parameters that you need. You can change that parameter in two ways - 1) completely reinstall MSSQL, whitch is time consuming operation. 2) Change collation with command entered in command prompt, whitch takes far less time and effort.
Hello to all database enthusiasts! Today, we dive into a prevalent issue many face with Microsoft SQL Server – the notorious Error: 5178. If you've seen this error:
Error: 5178, Severity: 16, State: 1.
Cannot use file 'c:\Program Files\Microsoft SQL Server\MSSQL13.SQLEXPRESS\MSSQL\DATA\master.mdf' because it was originally formatted with sector size 4096 and is now on a volume with sector size 3072. Move the file to a volume with a sector size that is the same as or smaller than the original sector size.
You'll understand the struggle. But fear not! This blog will guide you step-by-step to resolve this Microsoft SQL Server error using a virtual hard drive technique.
Hello. I was asked to migrate hosting spaces of websitepanel hosting panel to the other server, so that new and old hosting plans would work on the new server. After transferring resources to the new server, you need to update the websitepanel database, otherwise it will continue to use the old servers. This can be done using a TSQL script.
Русский
English
