Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- EXECUTE AS USER = 'adventure-works*david0';
- INSERT INTO [dbo].[DimEmployee] ([ParentEmployeeKey], [FirstName], [LastName], [Title],
- [LoginID], [NameStyle], [CurrentFlag], [SalesPersonFlag])
- VALUES (18, 'Joseph', 'Roberts', 'Production Technician - WC60', 'JRoberts', 0, 1, 0)
- REVERT;
- Msg 33504, Level 16, State 1, Line 2
- The attempted operation failed because the target object AdventureworksDW2016CTP3.dbo.DimEmployee' has a block predicate that conflicts with this operation. If the operation is performed on a view, the block predicate might be enforced on the underlying table. Modify the operation to target only the rows that are allowed by the block predicate.
- The statement has been terminated.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement