Show TOC

SQL Server Management StudioLocate this document in the navigation structure

Microsoft SQL Server Management Studio is a rich, integrated administrative graphical tool client, which is designed to do all administrative tasks of SQL Server. You can use SQL Server Management Studio to access, configure, manage, administrator and develop all components of SQL Server. SQL Server Management Studio with its easy-to-use graphical tools, rich script editors and command help provides SQL Server access to developers and administrators of all skills.

SQL Server Management Studio combines the features of SQL Server Enterprise Manager, Query analyzer and Analysis Manager, which were included in the previous releases, into one powerful tool for SQL Server developers and administrators.

In an SAP environment, you can perform the following tasks with SQL Server Management Studio:

  • Register SQL Servers
  • Connect to multiple SQL Server instances
  • Configure server properties
  • Manage databases
  • Create objects, for example, databases, tables, database users, and logins
  • Attach and detach databases
  • View SQL error logs
  • Monitor current activity
  • Run SQL Server queries
  • Access SQL Server agent error logs
  • Check the jobs created in SQL Agent by SAP monitor transactions