Adding date/time column to audit table
I just added a column called AuditDate with a default value of GetDate()
and now I get this message.
Column name or number of supplied values does not match table definition.
ALTER TRIGGER [dbo].[OrdersInsertUpdate]
ON [dbo].[Orders]
AFTER INSERT, UPDATE
AS
BEGIN
SET NOCOUNT ON;
INSERT INTO OrdersAudit SELECT * FROM INSERTED
END
How can I correct this?
and now I get this message.
Column name or number of supplied values does not match table definition.
ALTER TRIGGER [dbo].[OrdersInsertUpdate]
ON [dbo].[Orders]
AFTER INSERT, UPDATE
AS
BEGIN
SET NOCOUNT ON;
INSERT INTO OrdersAudit SELECT * FROM INSERTED
END
How can I correct this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER