List of procedures

CollapseAll image

Collapse image Procedures


Name  Schema  Description Input  Output  Encrypted Creation date
[AUDIT_prc_AggregateReport] dbo   10 0   21.09.2016 
[AUDIT_prc_Analyze] dbo   0 10   21.09.2016 
[AUDIT_prc_DDLReport] dbo   6 0   21.09.2016 
[AUDIT_prc_DeleteArchitecture] dbo   1 0   21.09.2016 
[AUDIT_prc_Purge_AUDIT_LOG] dbo   4 0   21.09.2016 
[AUDIT_prc_ReportingAddFilterValue] dbo   2 0   21.09.2016 
[AUDIT_prc_ReportingEnd] dbo   0 0   21.09.2016 
[AUDIT_prc_ReportingStart] dbo   0 0   21.09.2016 
[AUDIT_prc_StandardReport] dbo   6 0   21.09.2016 
[uspAddOrderTrackingEvent] dbo   3 0   16.11.2015 
[uspGetBillOfMaterials] dbo   2 0   16.11.2015 
[uspGetEmployeeManagers] dbo   1 0   16.11.2015 
[uspGetManagerEmployees] dbo   1 0   16.11.2015 
[uspGetOrderTrackingBySalesOrderID] dbo   1 0   16.11.2015 
[uspGetOrderTrackingByTrackingNumber] dbo   1 0   16.11.2015 
[uspGetWhereUsedProductID] dbo   2 0   16.11.2015 
[uspLogError] dbo   0 1   23.10.2015 
[uspPrintError] dbo   0 0   23.10.2015 
[uspSearchCandidateResumes] dbo   4 0   16.11.2015 
[usp_DemoInitSeed] Demo   1 0   23.10.2015 
[usp_DemoReset] Demo   0 0   23.10.2015 
[sp_GetEmployee_Person_Info_AsOf] HumanResources   1 0   23.10.2015 
[sp_UpdateEmployee_Temporal] HumanResources   7 0   23.10.2015 
[uspUpdateEmployeeHireInfo] HumanResources   7 0   16.11.2015 
[uspUpdateEmployeeLogin] HumanResources   6 0   16.11.2015 
[uspUpdateEmployeePersonalInfo] HumanResources   5 0   16.11.2015 
[sp_DeletePerson_Temporal] Person   1 0   23.10.2015 
[sp_UpdatePerson_Temporal] Person   8 0   23.10.2015 
[usp_InsertSalesOrder_inmem] Sales   16 1   23.10.2015 
[usp_InsertSalesOrder_ondisk] Sales   16 1   23.10.2015 
[usp_UpdateSalesOrderShipInfo_inmem] Sales   7 0   23.10.2015 
[usp_UpdateSalesOrderShipInfo_native] Sales   7 0   23.10.2015 
[usp_UpdateSalesOrderShipInfo_ondisk] Sales   7 0   23.10.2015 
[test] SQLCop   0 0   21.09.2016 
[test Ad hoc distributed queries] SQLCop   0 0   19.09.2016 
[test Agent Service] SQLCop   0 0   19.09.2016 
[test Auto close] SQLCop   0 0   19.09.2016 
[test Auto create statistics] SQLCop   0 0   19.09.2016 
[test Auto Shrink] SQLCop   0 0   19.09.2016 
[test Auto update statistics] SQLCop   0 0   19.09.2016 
[test Buffer cache hit ratio] SQLCop   0 0   19.09.2016 
[test Column collation does not match database default] SQLCop   0 0   19.09.2016 
[test Column data types (Numeric vs. Int)] SQLCop   0 0   19.09.2016 
[test Column Name Problems] SQLCop   0 0   19.09.2016 
[test Columns of data type Text/nText] SQLCop   0 0   19.09.2016 
[test Columns with float data type] SQLCop   0 0   19.09.2016 
[test Columns with image data type] SQLCop   0 0   19.09.2016 
[test Compatibility Level] SQLCop   0 0   19.09.2016 
[test Database and Log files on the same disk] SQLCop   0 0   19.09.2016 
[test Database collation] SQLCop   0 0   19.09.2016 
[test Database Mail] SQLCop   0 0   19.09.2016 
[test Decimal Size Problem] SQLCop   0 0   19.09.2016 
[test Forwarded Records] SQLCop   0 0   19.09.2016 
[test Fragmented Indexes] SQLCop   0 0   19.09.2016 
[test Instant File Initialization] SQLCop   0 0   19.09.2016 
[test Login Language] SQLCop   0 0   19.09.2016 
[test Max degree of parallelism] SQLCop   0 0   19.09.2016 
[test Missing Foreign Key Indexes] SQLCop   0 0   19.09.2016 
[test Missing Foreign Keys] SQLCop   0 0   19.09.2016 
[test Old Backups] SQLCop   0 0   19.09.2016 
[test Ole Automation Procedures] SQLCop   0 0   19.09.2016 
[test Orphaned Users] SQLCop   0 0   19.09.2016 
[test Page life expectancy] SQLCop   0 0   19.09.2016 
[test Procedures Named SP_] SQLCop   0 0   19.09.2016 
[test Procedures that call undocumented procedures] SQLCop   0 0   19.09.2016 
[test Procedures using dynamic SQL without sp_executesql] SQLCop   0 0   19.09.2016 
[test Procedures with @@Identity] SQLCop   0 0   19.09.2016 
[test Procedures With SET ROWCOUNT] SQLCop   0 0   19.09.2016 
[test Procedures without SET NOCOUNT ON] SQLCop   0 0   19.09.2016 
[test Service Account] SQLCop   0 0   19.09.2016 
[test SMO and DMO] SQLCop   0 0   19.09.2016 
[test Table name problems] SQLCop   0 0   19.09.2016 
[test Tables that start with tbl] SQLCop   0 0   19.09.2016 
[test Tables without a primary key] SQLCop   0 0   19.09.2016 
[test Tables without any data] SQLCop   0 0   19.09.2016 
[test UniqueIdentifier with NewId] SQLCop   0 0   19.09.2016 
[test Unnamed Constraints] SQLCop   0 0   19.09.2016 
[test User Aliases] SQLCop   0 0   19.09.2016 
[test Varchar Size Problem] SQLCop   0 0   19.09.2016 
[test Views with order by] SQLCop   0 0   19.09.2016 
[test Wide Table] SQLCop   0 0   19.09.2016 
[test xp_cmdshell is enabled] SQLCop   0 0   19.09.2016 
Total: 82 procedure(s)

Collapse image See also


Functions

Database overview