Database Manager

Database Manager

HelpID: 460022004, 460022011, 460022016, 460022019, 460022007

Database Manager is a “view only” utility for exploring your SQL Server. It provides full access to all databases on the server to view the SQL stored procedures, tables and views.

Navigation: Tools >> Utilities >> System >> SQL Database Manager

Server Properties: select the Server in the tree-view, then click the Properties button. The Server Properties window shows information about the configuration of the SQL Server, such as the number of processors, amount of memory, auto-start parameters, and memory usage. Consult SQL Server documentation for more information about each setting/property.

Stored Procedures: expand the tree-view to display the database objects, then click on Stored Procedures. The list-view on the right fills with the stored procedures in the selected database. Either double-click on a stored procedure, or select it and click properties, to view the Stored Procedure Properties.

Tables: expand the tree-view to display the database objects, then click on Tables. The list-view on the right fills with the tables in the selected database. Either double-click on a table, or select it and click Properties, to view the Table Properties. On the Database Manager window, Click Show >> All to view the data in the table.