Comments by Nikola Milovanovic (Top 3 by date)

Sorry for my late response:

create trigger [dbo].[Update_StavkaKataloga_GodinaKataloga]
on [dbo].[StavkaKataloga]
AFTER UPDATE
as
declare @GodinaKataloga int
select @GodinaKataloga=GodinaKataloga from inserted
if @GodinaKataloga not like (select GodinaKataloga from deleted)
begin
raiserror('Zabranjeno je direktno azuriranje GodineKataloga u StavciKataloga!', 16,1)
rollback
end

i dont want to allow the user to manualy update value in GodinaKataloga, and raise an error - Forbiden...

@Wendelius thanks for your reply! I tried your code and it worked, but before I saw yours I tried this one

create trigger Update_Katalog_Naziv
on Katalog
after update
as
if update (Godina)
begin
update StavkaKataloga
set GodinaKataloga=(select top 1 Godina from inserted)
from dbo.StavkaKataloga s
INNER JOIN INSERTED i ON s.IDKataloga = i.IDKataloga join Katalog k on s.IDKataloga = k.IDKataloga
where k.IDKataloga = s.IDKataloga
end

I am very thankful for your solution! The only thing that matters now is that all 3 options only work with lines disable trigger and enable trigger. I still cant find a way to make any of my solutions work without those lines. Are those lines mandatory with SQL server?