I spent a couple of lunchtimes going through Sqlserver Management Studio’s ‘Object Explorer’ panel, typing up all the different elements. This might seem like an odd thing to do, but I thought it might be useful for the following reasons:

  • as a reference. A searchable list of where everything is
  • as the beginnings of a checklist. Making a system wide change it might be handy to scan through this list and consider whether there’s an impact on each element
  • to get me blogging again :)

Databases
  System Databases
  Database Snapshots
  User Databases
    Database Diagrams
    Tables
    Views
    Synonyms
    Programmability
      Stored Procedures
      Functions
      Triggers
      Assemblies
      Types
      Rules
      Defaults
      Plan Guides
    Service Broker
      Message Types
      Contracts
      Queues
      Services
      Routes
      Remote ServiceBindings
      Broker Priorities
    Storage
      Full Text Catalogs
      Partition Schenes
      Patition Functions
      Full Text Stoplists
    Security
      Users
      Roles
      Schemas
      Asymmetric Keys
      Certificates
      Symmetric Keys
      Database Audit Specifications
Security
  Logins
  Server Roles
  Credentials
  Cryptographic Providers
  Audits
  Server Audit Specifications
Server Objects
  Backup Devices
  Endpoints
    System Endpoints
      Database Mirroring
      Service Broker
      SOAP
      TSQL
        Dedicated Admin Connection
        TSQL Default TCP
        TSQL Default VIA
        TSQL Local Machine
        TSQL Named Pipes
    Database Mirroring
    Service Broker
    SOAP
    TSQL
  Linked Servers
    Providers
  Triggers
Replication
  Local publications
  Local subscriptions
Management
  Data-tier Applications
  Policy Management
    Policies
      System Policies
    Conditions
      System Conditions
    Facets
  Data Collection
  Resource Governor
    Resource Pools
      System Resource Pools
  Maintenance Plans
SQL Server Logs
  Database Mail
  Distributed Trnasaction Co-ordinator
Legacy
  Database Maintenance Plans
  Data Transformation Services
  SQL Mail
SQL Server Agent
  Jobs
  Alerts
  Operators
  Proxies
  Error Logs