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'

  • SQL
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

What is MariaDB?

MariaDB is a fork of MySQL. The database structure and indexes of MariaDB are the same as MySQL....

Can I set my database hostname as 'localhost'?

No, you would need to set the database hostname as the server that it's on at HostMaria - Cloud....

What's the maximum MySQL database size allowed?

At HostMaria - Cloud, each MySQL database you create can store up to 1024 MB (1 GB) of data. As...

What is MS-SQL?

Microsoft SQL Server is a relational database management system (RDMS) developed by Microsoft. As...

Can I view my FTP, email address, or database passwords?

We encrypt all FTP, email and database passwords so they are not visible as plain text inside...