Database Objects AdventureWorks - Revision history

Bot at 22:05, 2 February 2010

2010-02-02T22:05:00Z

Bot at 21:57, 2 February 2010

2010-02-02T21:57:53Z

Bot at 21:36, 2 February 2010

2010-02-02T21:36:27Z

Bot at 22:24, 28 December 2009

2009-12-28T22:24:24Z

Bot at 21:53, 28 December 2009

2009-12-28T21:53:58Z

Bot at 14:30, 3 January 2009

2009-01-03T14:30:12Z

Bot at 12:33, 3 January 2009

2009-01-03T12:33:11Z

Show changes

Ho: Removing all content from page

2009-01-03T12:33:05Z

Removing all content from page

Show changes

Bot at 12:30, 3 January 2009

2009-01-03T12:30:01Z

Bot: New page: == wikibot == === Tables === Address (Person) AddressType (Person) AWBuildVersion (dbo) [[P...

2009-01-03T12:28:52Z

New page: == wikibot == === Tables === Address (Person) AddressType (Person) AWBuildVersion (dbo) [[P...

New page

== wikibot ==

=== Tables ===

[[Person.Address_(table)|Address (Person)]]

[[Person.AddressType_(table)|AddressType (Person)]]

[[dbo.AWBuildVersion_(table)|AWBuildVersion (dbo)]]

[[Production.BillOfMaterials_(table)|BillOfMaterials (Production)]]

[[Person.Contact_(table)|Contact (Person)]]

[[Sales.ContactCreditCard_(table)|ContactCreditCard (Sales)]]

[[Person.ContactType_(table)|ContactType (Person)]]

[[Person.CountryRegion_(table)|CountryRegion (Person)]]

[[Sales.CountryRegionCurrency_(table)|CountryRegionCurrency (Sales)]]

[[Sales.CreditCard_(table)|CreditCard (Sales)]]

[[Production.Culture_(table)|Culture (Production)]]

[[Sales.Currency_(table)|Currency (Sales)]]

[[Sales.CurrencyRate_(table)|CurrencyRate (Sales)]]

[[Sales.Customer_(table)|Customer (Sales)]]

[[Sales.CustomerAddress_(table)|CustomerAddress (Sales)]]

[[dbo.DatabaseLog_(table)|DatabaseLog (dbo)]]

[[HumanResources.Department_(table)|Department (HumanResources)]]

[[Production.Document_(table)|Document (Production)]]

[[HumanResources.Employee_(table)|Employee (HumanResources)]]

[[HumanResources.EmployeeAddress_(table)|EmployeeAddress (HumanResources)]]

[[HumanResources.EmployeeDepartmentHistory_(table)|EmployeeDepartmentHistory (HumanResources)]]

[[HumanResources.EmployeePayHistory_(table)|EmployeePayHistory (HumanResources)]]

[[dbo.ErrorLog_(table)|ErrorLog (dbo)]]

[[Production.Illustration_(table)|Illustration (Production)]]

[[Sales.Individual_(table)|Individual (Sales)]]

[[HumanResources.JobCandidate_(table)|JobCandidate (HumanResources)]]

[[Production.Location_(table)|Location (Production)]]

[[Production.Product_(table)|Product (Production)]]

[[Production.ProductCategory_(table)|ProductCategory (Production)]]

[[Production.ProductCostHistory_(table)|ProductCostHistory (Production)]]

[[Production.ProductDescription_(table)|ProductDescription (Production)]]

[[Production.ProductDocument_(table)|ProductDocument (Production)]]

[[Production.ProductInventory_(table)|ProductInventory (Production)]]

[[Production.ProductListPriceHistory_(table)|ProductListPriceHistory (Production)]]

[[Production.ProductModel_(table)|ProductModel (Production)]]

[[Production.ProductModelIllustration_(table)|ProductModelIllustration (Production)]]

[[Production.ProductModelProductDescriptionCulture_(table)|ProductModelProductDescriptionCulture (Production)]]

[[Production.ProductPhoto_(table)|ProductPhoto (Production)]]

[[Production.ProductProductPhoto_(table)|ProductProductPhoto (Production)]]

[[Production.ProductReview_(table)|ProductReview (Production)]]

[[Production.ProductSubcategory_(table)|ProductSubcategory (Production)]]

[[Purchasing.ProductVendor_(table)|ProductVendor (Purchasing)]]

[[Purchasing.PurchaseOrderDetail_(table)|PurchaseOrderDetail (Purchasing)]]

[[Purchasing.PurchaseOrderHeader_(table)|PurchaseOrderHeader (Purchasing)]]

[[Sales.SalesOrderDetail_(table)|SalesOrderDetail (Sales)]]

[[Sales.SalesOrderHeader_(table)|SalesOrderHeader (Sales)]]

[[Sales.SalesOrderHeaderSalesReason_(table)|SalesOrderHeaderSalesReason (Sales)]]

[[Sales.SalesPerson_(table)|SalesPerson (Sales)]]

[[Sales.SalesPersonQuotaHistory_(table)|SalesPersonQuotaHistory (Sales)]]

[[Sales.SalesReason_(table)|SalesReason (Sales)]]

[[Sales.SalesTaxRate_(table)|SalesTaxRate (Sales)]]

[[Sales.SalesTerritory_(table)|SalesTerritory (Sales)]]

[[Sales.SalesTerritoryHistory_(table)|SalesTerritoryHistory (Sales)]]

[[Production.ScrapReason_(table)|ScrapReason (Production)]]

[[HumanResources.Shift_(table)|Shift (HumanResources)]]

[[Purchasing.ShipMethod_(table)|ShipMethod (Purchasing)]]

[[Sales.ShoppingCartItem_(table)|ShoppingCartItem (Sales)]]

[[Sales.SpecialOffer_(table)|SpecialOffer (Sales)]]

[[Sales.SpecialOfferProduct_(table)|SpecialOfferProduct (Sales)]]

[[Person.StateProvince_(table)|StateProvince (Person)]]

[[Sales.Store_(table)|Store (Sales)]]

[[Sales.StoreContact_(table)|StoreContact (Sales)]]

[[Production.TransactionHistory_(table)|TransactionHistory (Production)]]

[[Production.TransactionHistoryArchive_(table)|TransactionHistoryArchive (Production)]]

[[Production.UnitMeasure_(table)|UnitMeasure (Production)]]

[[Purchasing.Vendor_(table)|Vendor (Purchasing)]]

[[Purchasing.VendorAddress_(table)|VendorAddress (Purchasing)]]

[[Purchasing.VendorContact_(table)|VendorContact (Purchasing)]]

[[Production.WorkOrder_(table)|WorkOrder (Production)]]

[[Production.WorkOrderRouting_(table)|WorkOrderRouting (Production)]]

=== Views ===

[[Person.vAdditionalContactInfo_(view)|vAdditionalContactInfo (Person)]]

[[HumanResources.vEmployee_(view)|vEmployee (HumanResources)]]

[[HumanResources.vEmployeeDepartment_(view)|vEmployeeDepartment (HumanResources)]]

[[HumanResources.vEmployeeDepartmentHistory_(view)|vEmployeeDepartmentHistory (HumanResources)]]

[[Sales.vIndividualCustomer_(view)|vIndividualCustomer (Sales)]]

[[Sales.vIndividualDemographics_(view)|vIndividualDemographics (Sales)]]

[[HumanResources.vJobCandidate_(view)|vJobCandidate (HumanResources)]]

[[HumanResources.vJobCandidateEducation_(view)|vJobCandidateEducation (HumanResources)]]

[[HumanResources.vJobCandidateEmployment_(view)|vJobCandidateEmployment (HumanResources)]]

[[Production.vProductAndDescription_(view)|vProductAndDescription (Production)]]

[[Production.vProductModelCatalogDescription_(view)|vProductModelCatalogDescription (Production)]]

[[Production.vProductModelInstructions_(view)|vProductModelInstructions (Production)]]

[[Sales.vSalesPerson_(view)|vSalesPerson (Sales)]]

[[Sales.vSalesPersonSalesByFiscalYears_(view)|vSalesPersonSalesByFiscalYears (Sales)]]

[[Person.vStateProvinceCountryRegion_(view)|vStateProvinceCountryRegion (Person)]]

[[Sales.vStoreWithDemographics_(view)|vStoreWithDemographics (Sales)]]

[[Purchasing.vVendor_(view)|vVendor (Purchasing)]]

=== Procedures ===

[[dbo.uspGetBillOfMaterials_(procedure)|uspGetBillOfMaterials (dbo)]]

[[dbo.uspGetEmployeeManagers_(procedure)|uspGetEmployeeManagers (dbo)]]

[[dbo.uspGetManagerEmployees_(procedure)|uspGetManagerEmployees (dbo)]]

[[dbo.uspGetWhereUsedProductID_(procedure)|uspGetWhereUsedProductID (dbo)]]

[[dbo.uspLogError_(procedure)|uspLogError (dbo)]]

[[dbo.uspPrintError_(procedure)|uspPrintError (dbo)]]

[[HumanResources.uspUpdateEmployeeHireInfo_(procedure)|uspUpdateEmployeeHireInfo (HumanResources)]]

[[HumanResources.uspUpdateEmployeeLogin_(procedure)|uspUpdateEmployeeLogin (HumanResources)]]

[[HumanResources.uspUpdateEmployeePersonalInfo_(procedure)|uspUpdateEmployeePersonalInfo (HumanResources)]]

=== Functions ===

[[dbo.ufnGetAccountingEndDate_(function)|ufnGetAccountingEndDate (dbo)]]

[[dbo.ufnGetAccountingStartDate_(function)|ufnGetAccountingStartDate (dbo)]]

[[dbo.ufnGetDocumentStatusText_(function)|ufnGetDocumentStatusText (dbo)]]

[[dbo.ufnGetProductDealerPrice_(function)|ufnGetProductDealerPrice (dbo)]]

[[dbo.ufnGetProductListPrice_(function)|ufnGetProductListPrice (dbo)]]

[[dbo.ufnGetProductStandardCost_(function)|ufnGetProductStandardCost (dbo)]]

[[dbo.ufnGetPurchaseOrderStatusText_(function)|ufnGetPurchaseOrderStatusText (dbo)]]

[[dbo.ufnGetSalesOrderStatusText_(function)|ufnGetSalesOrderStatusText (dbo)]]

[[dbo.ufnGetStock_(function)|ufnGetStock (dbo)]]

[[dbo.ufnLeadingZeros_(function)|ufnLeadingZeros (dbo)]]

[[dbo.ufnGetContactInformation_(function)|ufnGetContactInformation (dbo)]]

@@ Line 1: / Line 1: @@
 == wikibot ==
-adventureworks (mie 091228.2156)
+adventureworks (mie60)
 === Tables ===
@@ Line 266: / Line 266: @@
 === Database Triggers ===
-[[Database trigger to audit all of the DDL changes made to the AdventureWorks database._(database_trigger)|Database trigger to audit all of the DDL changes made to the AdventureWorks database.]]
+[[ddlDatabaseTriggerLog_(database_trigger)|ddlDatabaseTriggerLog]]

@@ Line 1: / Line 1: @@
 == wikibot ==
-adventureworks (mie60)
+adventureworks (mie 091228.2156)
 === Tables ===
@@ Line 266: / Line 266: @@
 === Database Triggers ===
-[[ddlDatabaseTriggerLog_(database_trigger)|ddlDatabaseTriggerLog]]
+[[Database trigger to audit all of the DDL changes made to the AdventureWorks database._(database_trigger)|Database trigger to audit all of the DDL changes made to the AdventureWorks database.]]

@@ Line 1: / Line 1: @@
 == wikibot ==
-adventureworks (mie 091228.2328)
+adventureworks (mie60)
 === Tables ===
@@ Line 263: / Line 263: @@
 [[Sales.StoreSurveySchemaCollection_(xml_schema_collection)|StoreSurveySchemaCollection (Sales)]]

@@ Line 1: / Line 1: @@
 == wikibot ==
-adventureworks (mie 091228.2156)
+adventureworks (mie 091228.2328)
 === Tables ===

@@ Line 1: / Line 1: @@
 == wikibot ==
-adventureworks (mie55)
+adventureworks (mie 091228.2156)
 === Tables ===