CREATE PROCEDURE [dbo].[up_item_owner_update] @character_id [uniqueidentifier], @auth_id [uniqueidentifier], @item_id [uniqueidentifier] as set nocount on update dbo.N_InventoryItem set character_id = @character_id , auth_id = @auth_id where item_uid = @item_id; return @@error