How do I manage my Microsoft SQL database?

How do I manage my Microsoft SQL database?

We recommend using SQL Server Management Studio (SSMS) for managing your Microsoft SQL databases. 

This industry-standard software provides a comprehensive environment for Microsoft SQL database creation, access, configuration, development, and other management features. It includes a variety of components including visual database tools, code and text editors, object management, boilerplate text management, and more. With SSMS you can deploy, monitor, and upgrade the data-tier components used by your applications, as well as build queries and scripts.

SSMS also helps you download and back up your MS SQL databases, which we recommend you do at regular intervals in the interests of best practice security.

You can download the software for free on the Microsoft SSMS download page.

To connect remotely you will need to use Server 'mssql.stackcp.com'.

    • Related Articles

    • How do I import a .sql file via phpMyAdmin?

      You can use phpMyAdmin to import an .SQL file with your database information. To do this: Log in to your database via phpMyAdmin (Here > Manage Hosting > [select package] > phpMyAdmin)  Choose the database you want to import your .SQL file to from ...

    • How do I import a .sql file via phpMyAdmin?

      You can use phpMyAdmin to import an .SQL file with your database information. To do this: Log in to your database via phpMyAdmin (HERE > Manage Hosting > [select package] > phpMyAdmin)  Choose the database you want to import your .SQL file to from ...

    • How do I import a .sql file via phpMyAdmin?

      You can use phpMyAdmin to import an .SQL file with your database information. To do this: Log in to your database via phpMyAdmin (Login HERE > Manage Hosting > [select package] > phpMyAdmin)  Choose the database you want to import your .SQL file to ...

    • How do I import a .sql file via phpMyAdmin?

      You can use phpMyAdmin to import an .SQL file with your database information. To do this: Log in to your database via phpMyAdmin (Login HERE > Manage Hosting > [select package] > phpMyAdmin)  Choose the database you want to import your .SQL file to ...

    • How do I create a MySQL database?

      You can create MySQL databases in seconds directly from your VISYOO control panel.  This option is unavailable for packages hosted on our WordPress platform due to its WP-optimised nature. If you need to create a MySQL database, you'll need to move ...