I want to check the quantity of a good before we ship with a trigger that will fire a message that there isn't enough stuff if the quantity purchased is more than the inventory.

So here is a trigger on the inventory table.

for some reason, it won't recognize my table correctly.

In my stockqty is a valid field in inventory.

reate trigger InventoryUpdateTriggerTRG on inventory
for update 
as 
declare 
 @myInventoryID as integer,
 @myQTY as integer;
begin
  if update (stockqty)
  begin
   if inserted.stockqty<0
    begin
    rollback transaction
    print ' not enough goodies to go around.'
    print ' We might want to re order'
    end
  end
end