Properties
| Has DB Access |  |
| Login | INNOVASYS-LOCAL\administrator |
| System Object | |
Roles
Tables
| Table | Description |
|---|---|
| dbo.AWBuildVersion | Current version number of the AdventureWorks sample database. |
| dbo.DatabaseLog | Audit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog. |
| dbo.ErrorLog | 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 Procedure | Description |
|---|---|
| dbo.uspGetBillOfMaterials | Description for uspGetBillOfMaterials in TSQLStored procedure using a recursive query to return a multi-level bill of material for the specified ProductID. |
| dbo.uspGetEmployeeManagers | Stored procedure using a recursive query to return the direct and indirect managers of the specified employee. |
| dbo.uspGetManagerEmployees | Stored procedure using a recursive query to return the direct and indirect employees of the specified manager. |
| dbo.uspGetWhereUsedProductID | Stored procedure using a recursive query to return all components or assemblies that directly or indirectly use the specified ProductID. |
| dbo.uspLogError | 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. |
| dbo.uspPrintError | 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 Function | Description |
|---|---|
| dbo.ufnGetAccountingEndDate | Scalar function used in the uSalesOrderHeader trigger to set the starting account date. |
| dbo.ufnGetAccountingStartDate | Scalar function used in the uSalesOrderHeader trigger to set the ending account date. |
| dbo.ufnGetContactInformation | Table value function returning the first name, last name, job title and contact type for a given contact. |
| dbo.ufnGetDocumentStatusText | Scalar function returning the text representation of the Status column in the Document table. |
| dbo.ufnGetProductDealerPrice | Scalar function returning the dealer price for a given product on a particular order date. |
| dbo.ufnGetProductListPrice | Scalar function returning the list price for a given product on a particular order date. |
| dbo.ufnGetProductStandardCost | Scalar function returning the standard cost for a given product on a particular order date. |
| dbo.ufnGetPurchaseOrderStatusText | Scalar function returning the text representation of the Status column in the PurchaseOrderHeader table. |
| dbo.ufnGetSalesOrderStatusText | Scalar function returning the text representation of the Status column in the SalesOrderHeader table. |
| dbo.ufnGetStock | Scalar function returning the quantity of inventory in LocationID 6 (Miscellaneous Storage)for a specified ProductID. |
| dbo.ufnLeadingZeros | Scalar function used by the Sales.Customer table to help set the account number. |
User Defined Data Types
| User Defined Data Type | Description |
|---|---|
| dbo.AccountNumber | |
| dbo.Flag | |
| dbo.Name | |
| dbo.NameStyle | |
| dbo.OrderNumber | |
| dbo.Phone |
Permissions
No permissions defined
See Also