Advertisement
Guest User

Untitled

a guest
Aug 29th, 2016
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. EXECUTE AS USER = 'adventure-works*david0';
  2. INSERT INTO [dbo].[DimEmployee] ([ParentEmployeeKey], [FirstName], [LastName], [Title],
  3. [LoginID], [NameStyle], [CurrentFlag], [SalesPersonFlag])
  4. VALUES (18, 'Joseph', 'Roberts', 'Production Technician - WC60', 'JRoberts', 0, 1, 0)
  5. REVERT;
  6.  
  7. Msg 33504, Level 16, State 1, Line 2
  8. 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.
  9. The statement has been terminated.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement