Northwind Database (Document! X Sample)
AdventureWorks Database / dbo User
In This Topic
    dbo User
    In This Topic
    Properties
    Has DB Access
    Login
    System Object
    Roles
    RoleDescription
     
     
    Tables
    TableDescription
    Current version number of the AdventureWorks 2016 sample database.
    Audit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog.
    Audit table tracking errors in the the AdventureWorks database that are caught by the CATCH block of a TRY...CATCH construct. Data is inserted by stored procedure dbo.uspLogError when it is executed from inside the CATCH block of a TRY...CATCH construct.
    Stored Procedures
    Stored ProcedureDescription
    Stored procedure using a recursive query to return a multi-level bill of material for the specified ProductID.
    Stored procedure using a recursive query to return the direct and indirect managers of the specified employee.
    Stored procedure using a recursive query to return the direct and indirect employees of the specified manager.
    Stored procedure using a recursive query to return all components or assemblies that directly or indirectly use the specified ProductID.
    Logs error information in the ErrorLog table about the error that caused execution to jump to the CATCH block of a TRY...CATCH construct. Should be executed from within the scope of a CATCH block otherwise it will return without inserting error information.
    Prints error information about the error that caused execution to jump to the CATCH block of a TRY...CATCH construct. Should be executed from within the scope of a CATCH block otherwise it will return without printing any error information.
     
    User Defined Functions
    User Defined FunctionDescription
    Scalar function used in the uSalesOrderHeader trigger to set the starting account date.
    Scalar function used in the uSalesOrderHeader trigger to set the ending account date.
    Table value function returning the first name, last name, job title and contact type for a given contact.
    Scalar function returning the text representation of the Status column in the Document table.
    Scalar function returning the dealer price for a given product on a particular order date.
    Scalar function returning the list price for a given product on a particular order date.
    Scalar function returning the standard cost for a given product on a particular order date.
    Scalar function returning the text representation of the Status column in the PurchaseOrderHeader table.
    Scalar function returning the text representation of the Status column in the SalesOrderHeader table.
    Scalar function returning the quantity of inventory in LocationID 6 (Miscellaneous Storage)for a specified ProductID.
    Scalar function used by the Sales.Customer table to help set the account number.
    User Defined Data Types
    User Defined Data TypeDescription
     
     
     
     
     
     
    Permissions

    No permissions defined

    See Also

    Related Objects

    AdventureWorks Database