Вот фикс на пати.

USE [Telecaster]
GO
/****** Object: StoredProcedure [dbo].[smp_insert_party] Script Date: 01/26/2013 21:53:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- start of smp_insert_party
ALTER PROCEDURE [dbo].[smp_insert_party]

@IN_NAME NVARCHAR(31),
@IN_PARTY_SID INT,
@IN_LEADER_SID INT,
@IN_PARTY_TYPE INT

AS
SET NOCOUNT ON

INSERT INTO dbo.Party( sid, name, leader_id, share_mode, party_type, lead_party_id ) VALUES( @IN_PARTY_SID, @IN_NAME, @IN_LEADER_SID, 0, @IN_PARTY_TYPE, 0 );

2

USE [Telecaster]
GO
/****** Object: StoredProcedure [dbo].[smp_set_party] Script Date: 01/26/2013 21:54:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- start of smp_set_party_leader

-- start of smp_set_party
ALTER PROCEDURE [dbo].[smp_set_party]
@IN_NAME NVARCHAR(31),
@IN_SID INT

AS
SET NOCOUNT ON

DECLARE @SID INT
SET @SID = 0

SELECT @SID = sid FROM Character WITH (NOLOCK) WHERE name = @IN_NAME

update Character set party_id = @IN_SID where sid = @SID