hosttexas.blogg.se

(1) COLLATE Latin1_General_CS_AS NOT NULL, (50) COLLATE Latin1_General_CS_AS NOT NULL, (256) COLLATE Latin1_General_CS_AS NOT NULL, (15) COLLATE Latin1_General_CS_AS NOT NULL, HumanResources.vEmployeeDepartmentHistoryĬREATE TABLE. Objects that depend on HumanResources.Employee ManagerID relies upon remote PK_Employee_EmployeeID

Used to support a merge replication sample.ĭate and time the record was last updated.įoreign keys dependencies: FK_Employee_Contact_ContactID:ĬontactID relies upon remote PK_Contact_ContactID ROWGUIDCOL number uniquely identifying the record. 1 = Salaried, exempt from collective bargaining. 0 = Hourly, not exempt from collective bargaining. Work title such as Buyer or Sales Representative. Manager to whom the employee is assigned. Identifies the employee in the Contact table. Unique national identification number such as a social security number. (4000) COLLATE Latin1_General_CS_AS NOT NULLĮmployee information such as salary, department, and title.

(126) COLLATE Latin1_General_CS_AS NULL, The message text of the error that occurred. The line number at which the error occurred. The name of the stored procedure or trigger where the error occurred. The state number of the error that occurred. The error number of the error that occurred. The user who executed the batch in which the error occurred. The date and time at which the error occurred. Data is inserted by stored procedure dbo.uspLogError when it is executed from inside the CATCH block of a TRY.CATCH construct. ( max) COLLATE Latin1_General_CS_AS NOT NULL,Īudit table tracking errors in the the AdventureWorks database that are caught by the CATCH block of a TRY.CATCH construct. The raw XML data generated by database trigger. The exact Transact-SQL statement that was executed. The object that was changed by the DDL statment. The schema to which the changed object belongs. The type of DDL statement that was executed. The date and time the DDL change occurred. Data is captured by the database trigger ddlDatabaseTriggerLog. Audit table tracking all DDL changes made to the AdventureWorks database.