sql

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. 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.