You searched for the word(s):
< 1 second(s)
-
Razvan, multumesc pentru raspuns, am fost putin surprins cand am vazut numele triggerului in postul tau ... se pare ca intotdeauna e bine sa citesti foarte atent mesajul de eroare . Intradevar exista triggerul:
CREATE TRIGGER [dbo].[dbProdU]
ON [dbo].[Product]
AFTER UPDATE
AS
BEGIN
SET NOCOUNT ON
DELETE FROM DBCXC.dbo.Produse ...
-
Salut,
are cineva idee de ce la executia query-ului
UPDATE Product SET UnitTechPrice=8.00 WHERE ProductID=499
folosind SQL Server Management Studio
apare eroarea:
Msg 544, Level 16, State 1, Procedure dbProdU, Line 15
Cannot insert explicit value for identity column in table 'Product' when IDENTITY_INSERT is set to OFF.
The statement has ...