• ▼MSDN Library - April 2000
    • ▶Welcome to the MSDN Library
    • ▶Visual Studio 6.0 Documentation
    • ▶Office Developer Documentation
    • ▶Windows CE Documentation
    • ▼Platform SDK
      • ▶Getting Started
      • ▶Design Strategies and Standards
      • ▶Base Services
      • ▶Component Services
      • ▼Data Access Services
        • ▶Microsoft Data Access Components (MDAC) SDK
        • ▶Jet and Replication Objects
        • ▶Microsoft XML SDK
        • ▼Microsoft SQL Server Programmer's Toolkit
          • ▶Getting Started
          • ▶What's New
          • ▶Installing SQL Server
          • ▶SQL Server Architecture
          • ▶Administering SQL Server
          • ▶Creating and Maintaining Databases
          • ▶Accessing and Changing Data
          • ▶Optimizing Database Performance
          • ▶Replication
          • ▶Data Transformation Services
          • ▶OLAP Services
          • ▶English Query
          • ▶Repository
          • ▶Building SQL Server Applications
          • ▶Troubleshooting
          • ▼How To
            • ▶Installing SQL Server
            • ▼SQL Server Enterprise Manager
              • ▼Administering SQL Server
                • ▶Starting, Pausing and Stopping SQL Server
                • ▶Backing Up and Restoring Databases
                • ▶Managing Servers
                • ▶Managing Clients
                • ▶Automating Administrative Tasks
                • ▼Managing Security
                  • How to set up Windows NT Authentication Mode security (Enterprise Manager)
                  • How to set up Mixed Mode security (Enterprise Manager)
                  • How to grant a Windows NT user or group login access to SQL Server (Enterprise Manager)
                  • How to grant a Windows NT user or group access to a database (Enterprise Manager)
                  • How to add a SQL Server login (Enterprise Manager)
                  • How to add a linked server login (Enterprise Manager)
                  • How to grant a SQL Server login access to a database (Enterprise Manager)
                  • How to create a SQL Server database role (Enterprise Manager)
                  • How to add a member to a SQL Server database role (Enterprise Manager)
                  • How to add a member to a fixed server role (Enterprise Manager)
                  • How to grant SQL Server login access to a user by using the Create Login Wizard (Enterprise Manager)
                  • How to view a SQL Server login or Windows NT user or group (Enterprise Manager)
                  • How to view a database user (Enterprise Manager)
                  • How to change the password of a SQL Server login (Enterprise Manager)
                  • How to change the default database of a login (Enterprise Manager)
                  • How to change the default language of a login (Enterprise Manager)
                  • How to remove a user or group from a database (Enterprise Manager)
                  • How to remove a SQL Server login (Enterprise Manager)
                  • How to revoke a Windows NT user or group login access from SQL Server (Enterprise Manager)
                  • How to deny login access to a Windows NT user or group (Enterprise Manager)
                  • How to remove a linked server login (Enterprise Manager)
                  • How to view the roles defined in the current database (Enterprise Manager)
                  • How to view the fixed server roles (Enterprise Manager)
                  • How to view the members of a database role (Enterprise Manager)
                  • How to remove a user account from a database role (Enterprise Manager)
                  • How to view the members of a fixed server role (Enterprise Manager)
                  • How to remove a login from a fixed server role (Enterprise Manager)
                  • How to remove a SQL Server role (Enterprise Manager)
                  • How to allow access by granting permissions (Enterprise Manager)
                  • How to grant statement permissions to users within a database (Enterprise Manager)
                  • How to grant permissions on multiple objects to a user, group, or role (Enterprise Manager)
                  • How to prevent access by denying permissions (Enterprise Manager)
                  • How to deny statement permissions from users within a database (Enterprise Manager)
                  • How to deny permissions on multiple objects to a user, group, or role (Enterprise Manager)
                  • How to revoke permissions on an object (Enterprise Manager)
                  • How to revoke statement permissions from users in a database (Enterprise Manager)
                  • How to revoke permissions on multiple objects from a user, group, or role (Enterprise Manager)
                  • How to create an application role (Enterprise Manager)
                  • How to remove an application role (Enterprise Manager)
                  • How to hide or reveal SQL Server on a network (Windows NT)
                • ▶Monitoring Server Performance and Activity
                • ▶Integrating SQL Server with Other Tools
              • ▶Creating and Maintaining Databases
              • ▶Accessing and Changing Data
              • ▶Optimizing Database Performance
              • ▶Replication
              • ▶Data Transformation Services
            • ▶Transact-SQL
            • ▶OLE DB
            • ▶ODBC
          • ▶Glossary
      • ▶Graphics and Multimedia Services
      • ▶Management Services
      • ▶Messaging and Collaboration Services
      • ▶Networking and Directory Services
      • ▶Security
      • ▶Tools and Languages
      • ▶User Interface Services
      • ▶Web Services
      • ▶Win32 API
    • ▶SDK Documentation
    • ▶DDK Documentation
    • ▶Windows Resource Kits
    • ▶Knowledge Base
    • ▶Technical Articles
    • ▶Backgrounders
    • ▶Specifications
    • ▶Books
    • ▶Partial Books
    • ▶Periodicals
    • ▶Samples