sql management studio

If you have large MSSQL database then you can shrink it to free up some space on SQL server. This shrinking process will remove the unused space from database. You can follow below steps to shrink database via Microsoft SQL Management Studio Login to your SQL server. Now expand databases and...

Collation indicates that how character data will be handled. Collation is a configuration level setting. You can follow below steps to change database Collation: Login to RDP server and open SQL Management Studio. Now right click on particular Database name and then click on “Properties”. A...