USE [SRO_VT_SHARD] GO /****** Object: StoredProcedure [dbo].[_STRG_FREE_ITEM_NoTX] Script Date: 12/03/2011 04:26:33 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO
ALTER procedure [dbo].[_STRG_FREE_ITEM_NoTX] @ItemToFree bigint as
if (not exists(select ItemID from _ItemPool with (nolock) where ItemID = @ItemToFree)) return -1 DELETE FROM _ItemPool where ItemID = @ItemToFree DELETE FROM _Items WHERE ID64 = @ItemToFree return 1