User: [AdventureWorks2016CTP3].[dbo]
Collapse all
Expand all
User properties
Name
Value
Name
[dbo]
Login
ID
1
Authentication type
Windows
Roles
Role
[db_owner]
[public]
Objects
Name
Type
[dbo].[AccountNumber]
Datatype
[dbo].[Flag]
Datatype
[dbo].[Name]
Datatype
[dbo].[NameStyle]
Datatype
[dbo].[OrderNumber]
Datatype
[dbo].[Phone]
Datatype
[Sales].[SalesOrderDetailType_inmem]
Datatype
[Sales].[SalesOrderDetailType_ondisk]
Datatype
[AW2014FullTextCatalog]
Fulltext Catalog
[dbo].[AUDIT_fn_HexToStr]
Function
[dbo].[AUDIT_fn_SqlVariantToString]
Function
[dbo].[ufnGetAccountingEndDate]
Function
[dbo].[ufnGetAccountingEndDate_native]
Function
[dbo].[ufnGetAccountingStartDate]
Function
[dbo].[ufnGetAccountingStartDate_native]
Function
[dbo].[ufnGetContactInformation]
Function
[dbo].[ufnGetDocumentStatusText]
Function
[dbo].[ufnGetDocumentStatusText_native]
Function
[dbo].[ufnGetProductDealerPrice]
Function
[dbo].[ufnGetProductListPrice]
Function
[dbo].[ufnGetProductStandardCost]
Function
[dbo].[ufnGetPurchaseOrderStatusText]
Function
[dbo].[ufnGetPurchaseOrderStatusText_native]
Function
[dbo].[ufnGetSalesOrderStatusText]
Function
[dbo].[ufnGetSalesOrderStatusText_native]
Function
[dbo].[ufnGetStock]
Function
[dbo].[ufnLeadingZeros]
Function
[dbo].[ufnLeadingZeros_native]
Function
[Sales].[vSalesOrderDetail_extended_inmem]
Function
[Sales].[vSalesOrderHeader_extended_inmem]
Function
[Security].[customerAccessPredicate]
Function
[dbo].[AUDIT_prc_AggregateReport]
Procedure
[dbo].[AUDIT_prc_Analyze]
Procedure
[dbo].[AUDIT_prc_DDLReport]
Procedure
[dbo].[AUDIT_prc_DeleteArchitecture]
Procedure
[dbo].[AUDIT_prc_Purge_AUDIT_LOG]
Procedure
[dbo].[AUDIT_prc_ReportingAddFilterValue]
Procedure
[dbo].[AUDIT_prc_ReportingEnd]
Procedure
[dbo].[AUDIT_prc_ReportingStart]
Procedure
[dbo].[AUDIT_prc_StandardReport]
Procedure
[dbo].[uspAddOrderTrackingEvent]
Procedure
[dbo].[uspGetBillOfMaterials]
Procedure
[dbo].[uspGetEmployeeManagers]
Procedure
[dbo].[uspGetManagerEmployees]
Procedure
[dbo].[uspGetOrderTrackingBySalesOrderID]
Procedure
[dbo].[uspGetOrderTrackingByTrackingNumber]
Procedure
[dbo].[uspGetWhereUsedProductID]
Procedure
[dbo].[uspLogError]
Procedure
[dbo].[uspPrintError]
Procedure
[dbo].[uspSearchCandidateResumes]
Procedure
[Demo].[usp_DemoInitSeed]
Procedure
[Demo].[usp_DemoReset]
Procedure
[HumanResources].[sp_GetEmployee_Person_Info_AsOf]
Procedure
[HumanResources].[sp_UpdateEmployee_Temporal]
Procedure
[HumanResources].[uspUpdateEmployeeHireInfo]
Procedure
[HumanResources].[uspUpdateEmployeeLogin]
Procedure
[HumanResources].[uspUpdateEmployeePersonalInfo]
Procedure
[Person].[sp_DeletePerson_Temporal]
Procedure
[Person].[sp_UpdatePerson_Temporal]
Procedure
[Sales].[usp_InsertSalesOrder_inmem]
Procedure
[Sales].[usp_InsertSalesOrder_ondisk]
Procedure
[Sales].[usp_UpdateSalesOrderShipInfo_inmem]
Procedure
[Sales].[usp_UpdateSalesOrderShipInfo_native]
Procedure
[Sales].[usp_UpdateSalesOrderShipInfo_ondisk]
Procedure
[SQLCop].[test]
Procedure
[SQLCop].[test Ad hoc distributed queries]
Procedure
[SQLCop].[test Agent Service]
Procedure
[SQLCop].[test Auto close]
Procedure
[SQLCop].[test Auto create statistics]
Procedure
[SQLCop].[test Auto Shrink]
Procedure
[SQLCop].[test Auto update statistics]
Procedure
[SQLCop].[test Buffer cache hit ratio]
Procedure
[SQLCop].[test Column collation does not match database default]
Procedure
[SQLCop].[test Column data types (Numeric vs. Int)]
Procedure
[SQLCop].[test Column Name Problems]
Procedure
[SQLCop].[test Columns of data type Text/nText]
Procedure
[SQLCop].[test Columns with float data type]
Procedure
[SQLCop].[test Columns with image data type]
Procedure
[SQLCop].[test Compatibility Level]
Procedure
[SQLCop].[test Database and Log files on the same disk]
Procedure
[SQLCop].[test Database collation]
Procedure
[SQLCop].[test Database Mail]
Procedure
[SQLCop].[test Decimal Size Problem]
Procedure
[SQLCop].[test Forwarded Records]
Procedure
[SQLCop].[test Fragmented Indexes]
Procedure
[SQLCop].[test Instant File Initialization]
Procedure
[SQLCop].[test Login Language]
Procedure
[SQLCop].[test Max degree of parallelism]
Procedure
[SQLCop].[test Missing Foreign Key Indexes]
Procedure
[SQLCop].[test Missing Foreign Keys]
Procedure
[SQLCop].[test Old Backups]
Procedure
[SQLCop].[test Ole Automation Procedures]
Procedure
[SQLCop].[test Orphaned Users]
Procedure
[SQLCop].[test Page life expectancy]
Procedure
[SQLCop].[test Procedures Named SP_]
Procedure
[SQLCop].[test Procedures that call undocumented procedures]
Procedure
[SQLCop].[test Procedures using dynamic SQL without sp_executesql]
Procedure
[SQLCop].[test Procedures with @@Identity]
Procedure
[SQLCop].[test Procedures With SET ROWCOUNT]
Procedure
[SQLCop].[test Procedures without SET NOCOUNT ON]
Procedure
[SQLCop].[test Service Account]
Procedure
[SQLCop].[test SMO and DMO]
Procedure
[SQLCop].[test Table name problems]
Procedure
[SQLCop].[test Tables that start with tbl]
Procedure
[SQLCop].[test Tables without a primary key]
Procedure
[SQLCop].[test Tables without any data]
Procedure
[SQLCop].[test UniqueIdentifier with NewId]
Procedure
[SQLCop].[test Unnamed Constraints]
Procedure
[SQLCop].[test User Aliases]
Procedure
[SQLCop].[test Varchar Size Problem]
Procedure
[SQLCop].[test Views with order by]
Procedure
[SQLCop].[test Wide Table]
Procedure
[SQLCop].[test xp_cmdshell is enabled]
Procedure
[dbo].[db_accessadmin]
Role
[dbo].[db_backupoperator]
Role
[dbo].[db_datareader]
Role
[dbo].[db_datawriter]
Role
[dbo].[db_ddladmin]
Role
[dbo].[db_denydatareader]
Role
[dbo].[db_denydatawriter]
Role
[dbo].[db_owner]
Role
[dbo].[db_securityadmin]
Role
[dbo].[public]
Role
[dbo].[SalesManagers]
Role
[dbo].[SalesPersons]
Role
[dbo].[AUDIT_LOG_DATA]
Table
[dbo].[AUDIT_LOG_DDL]
Table
[dbo].[AUDIT_LOG_TRANSACTIONS]
Table
[dbo].[AWBuildVersion]
Table
[dbo].[DatabaseLog]
Table
[dbo].[ErrorLog]
Table
[Demo].[DemoSalesOrderDetailSeed]
Table
[Demo].[DemoSalesOrderHeaderSeed]
Table
[HumanResources].[Department]
Table
[HumanResources].[Employee]
Table
[HumanResources].[Employee_Temporal]
Table
[HumanResources].[Employee_Temporal_History]
Table
[HumanResources].[EmployeeDepartmentHistory]
Table
[HumanResources].[EmployeePayHistory]
Table
[HumanResources].[JobCandidate]
Table
[HumanResources].[Shift]
Table
[Person].[Address]
Table
[Person].[AddressType]
Table
[Person].[BusinessEntity]
Table
[Person].[BusinessEntityAddress]
Table
[Person].[BusinessEntityContact]
Table
[Person].[ContactType]
Table
[Person].[CountryRegion]
Table
[Person].[EmailAddress]
Table
[Person].[Password]
Table
[Person].[Person]
Table
[Person].[Person_json]
Table
[Person].[Person_Temporal]
Table
[Person].[Person_Temporal_History]
Table
[Person].[PersonPhone]
Table
[Person].[PhoneNumberType]
Table
[Person].[StateProvince]
Table
[Production].[BillOfMaterials]
Table
[Production].[Culture]
Table
[Production].[Document]
Table
[Production].[Illustration]
Table
[Production].[Location]
Table
[Production].[Product]
Table
[Production].[Product_inmem]
Table
[Production].[Product_ondisk]
Table
[Production].[ProductCategory]
Table
[Production].[ProductCostHistory]
Table
[Production].[ProductDescription]
Table
[Production].[ProductDocument]
Table
[Production].[ProductInventory]
Table
[Production].[ProductListPriceHistory]
Table
[Production].[ProductModel]
Table
[Production].[ProductModelIllustration]
Table
[Production].[ProductModelProductDescriptionCulture]
Table
[Production].[ProductPhoto]
Table
[Production].[ProductProductPhoto]
Table
[Production].[ProductReview]
Table
[Production].[ProductSubcategory]
Table
[Production].[ScrapReason]
Table
[Production].[TransactionHistory]
Table
[Production].[TransactionHistoryArchive]
Table
[Production].[UnitMeasure]
Table
[Production].[WorkOrder]
Table
[Production].[WorkOrderRouting]
Table
[Purchasing].[ProductVendor]
Table
[Purchasing].[PurchaseOrderDetail]
Table
[Purchasing].[PurchaseOrderHeader]
Table
[Purchasing].[ShipMethod]
Table
[Purchasing].[Vendor]
Table
[Sales].[CountryRegionCurrency]
Table
[Sales].[CreditCard]
Table
[Sales].[Currency]
Table
[Sales].[CurrencyRate]
Table
[Sales].[Customer]
Table
[Sales].[CustomerPII]
Table
[Sales].[OrderTracking]
Table
[Sales].[PersonCreditCard]
Table
[Sales].[SalesOrder_json]
Table
[Sales].[SalesOrderDetail]
Table
[Sales].[SalesOrderDetail_inmem]
Table
[Sales].[SalesOrderDetail_ondisk]
Table
[Sales].[SalesOrderHeader]
Table
[Sales].[SalesOrderHeader_inmem]
Table
[Sales].[SalesOrderHeader_ondisk]
Table
[Sales].[SalesOrderHeaderSalesReason]
Table
[Sales].[SalesPerson]
Table
[Sales].[SalesPersonQuotaHistory]
Table
[Sales].[SalesReason]
Table
[Sales].[SalesTaxRate]
Table
[Sales].[SalesTerritory]
Table
[Sales].[SalesTerritoryHistory]
Table
[Sales].[ShoppingCartItem]
Table
[Sales].[SpecialOffer]
Table
[Sales].[SpecialOffer_inmem]
Table
[Sales].[SpecialOffer_ondisk]
Table
[Sales].[SpecialOfferProduct]
Table
[Sales].[SpecialOfferProduct_inmem]
Table
[Sales].[SpecialOfferProduct_ondisk]
Table
[Sales].[Store]
Table
[Sales].[TrackingEvent]
Table
[dbo].[tr_d_AUDIT_AWBuildVersion]
Trigger
[dbo].[tr_d_AUDIT_DatabaseLog]
Trigger
[dbo].[tr_d_AUDIT_ErrorLog]
Trigger
[dbo].[tr_i_AUDIT_DatabaseLog]
Trigger
[dbo].[tr_i_AUDIT_ErrorLog]
Trigger
[dbo].[tr_u_AUDIT_AWBuildVersion]
Trigger
[dbo].[tr_u_AUDIT_DatabaseLog]
Trigger
[HumanResources].[dEmployee]
Trigger
[HumanResources].[tr_d_AUDIT_Department]
Trigger
[HumanResources].[tr_d_AUDIT_Employee]
Trigger
[HumanResources].[tr_d_AUDIT_EmployeeDepartmentHistory]
Trigger
[HumanResources].[tr_d_AUDIT_EmployeePayHistory]
Trigger
[HumanResources].[tr_i_AUDIT_Department]
Trigger
[HumanResources].[tr_i_AUDIT_Employee]
Trigger
[HumanResources].[tr_i_AUDIT_EmployeeDepartmentHistory]
Trigger
[HumanResources].[tr_i_AUDIT_EmployeePayHistory]
Trigger
[HumanResources].[tr_u_AUDIT_Department]
Trigger
[HumanResources].[tr_u_AUDIT_Employee_Temporal]
Trigger
[HumanResources].[tr_u_AUDIT_EmployeeDepartmentHistory]
Trigger
[HumanResources].[tr_u_AUDIT_EmployeePayHistory]
Trigger
[Person].[iuPerson]
Trigger
[Production].[iWorkOrder]
Trigger
[Production].[uWorkOrder]
Trigger
[Purchasing].[dVendor]
Trigger
[Purchasing].[iPurchaseOrderDetail]
Trigger
[Purchasing].[uPurchaseOrderDetail]
Trigger
[Purchasing].[uPurchaseOrderHeader]
Trigger
[Sales].[iduSalesOrderDetail]
Trigger
[Sales].[uSalesOrderHeader]
Trigger
[amy0]
User
[brian3]
User
[david8]
User
[dbo]
User
[garrett1]
User
[guest]
User
[jae0]
User
[jillian0]
User
[josé1]
User
[linda3]
User
[lynn0]
User
[michael9]
User
[pamela0]
User
[rachel0]
User
[ranjit0]
User
[shu0]
User
[stephen0]
User
[syed0]
User
[tete0]
User
[tsvi0]
User
[dbo].[AUDIT_UNDO]
View
[dbo].[AUDIT_VIEW]
View
[HumanResources].[vEmployee]
View
[HumanResources].[vEmployeeDepartment]
View
[HumanResources].[vEmployeeDepartmentHistory]
View
[HumanResources].[vEmployeePersonTemporalInfo]
View
[HumanResources].[vJobCandidate]
View
[HumanResources].[vJobCandidateEducation]
View
[HumanResources].[vJobCandidateEmployment]
View
[Person].[vAdditionalContactInfo]
View
[Person].[vStateProvinceCountryRegion]
View
[Production].[vProductAndDescription]
View
[Production].[vProductModelCatalogDescription]
View
[Production].[vProductModelInstructions]
View
[Purchasing].[vVendorWithAddresses]
View
[Purchasing].[vVendorWithContacts]
View
[Sales].[vIndividualCustomer]
View
[Sales].[vPersonDemographics]
View
[Sales].[vSalesPerson]
View
[Sales].[vSalesPersonSalesByFiscalYears]
View
[Sales].[vStoreWithAddresses]
View
[Sales].[vStoreWithContacts]
View
[Sales].[vStoreWithDemographics]
View
[tr_ddl_AUDIT]
DDL Trigger
[db_accessadmin]
Schema
[db_backupoperator]
Schema
[db_datareader]
Schema
[db_datawriter]
Schema
[db_ddladmin]
Schema
[db_denydatareader]
Schema
[db_denydatawriter]
Schema
[db_owner]
Schema
[db_securityadmin]
Schema
[dbo]
Schema
[Demo]
Schema
[HumanResources]
Schema
[Person]
Schema
[Production]
Schema
[Purchasing]
Schema
[Sales]
Schema
[Security]
Schema
[SQLCop]
Schema
[guest]
Schema
[INFORMATION_SCHEMA]
Schema
[sys]
Schema
[HumanResources].[HRResumeSchemaCollection]
XML Schema Collection
[Person].[AdditionalContactInfoSchemaCollection]
XML Schema Collection
[Person].[IndividualSurveySchemaCollection]
XML Schema Collection
[Production].[ManuInstructionsSchemaCollection]
XML Schema Collection
[Production].[ProductDescriptionSchemaCollection]
XML Schema Collection
[Sales].[StoreSurveySchemaCollection]
XML Schema Collection
Total: 320 object(s)
SQL
NA
See also
List of users