• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part V: SQL Server/MSDE Administration

Part V: SQL Server/MSDE Administration

The purpose of the chapters in this part of the book is to explain the numerous tools and programming interfaces for administering Microsoft SQL Server and Microsoft Data Engine (MSDE). All administrative activities can be performed with specific programs, Transact-SQL commands, and system procedures, as well as with the SQL Distributed Management Objects (SQL-DMO) programming interface.

First, there is an introduction to the administrative features provided by an Access project for SQL Server and MSDE. Next, we present a description of SQL Server tools such as Enterprise Manager, Query Analyzer, Profiler, and so on.

We provide a review of the security features of SQL Server/MSDE, for example, creating users and user groups (roles) and defining access permissions.

Performing regular data backups and restoring backups are also part of SQL Server/MSDE operations.

Information is provided on Data Transformation Services (DTS), which facilitate the transfer of data between various data sources. Integrating external data sources with SQL Server/MSDE is also explained.

We also explain direct programming of SQL Server functions with the SQL-DMO library. You are also provided with a list of all system stored procedures with which you can call the administrative functions of SQL Server/MSDE.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint