При созданий гм акка в мскл,мскл выдает след ошибку.
Msg 2627, Level 14, State 1, Procedure pInsert_Staff, Line 27
Violation of UNIQUE KEY constraint 'IX_tbl_StaffAccount'. Cannot insert duplicate key in object 'dbo.tbl_StaffAccount'.
The statement has been terminated.
Stored Procedure: rf_user.dbo.pInsert_Staff
Заливаю этой командой
DECLARE @RC int
DECLARE @id varchar(13)
DECLARE @pw varchar(13)
DECLARE @depart varchar(32)
DECLARE @class varchar(12)
DECLARE @name varchar(12)
DECLARE @birthday varchar(10)
DECLARE @grade int
DECLARE @subgrade int
SELECT @id = 'ВАШ ЛОГИН'
SELECT @pw = 'ВАШ ПАРОЛЬ'
SELECT @depart = 'none'
SELECT @class = 'GM'
SELECT @name = 'name'
SELECT @birthday = 'None'
SELECT @grade = 4
SELECT @subgrade = 4
EXEC @RC = [rf_user].[dbo].[pInsert_Staff] @id, @pw, @depart, @class, @name, @birthday, @grade, @subgrade
DECLARE @PrnLine nvarchar(4000)
PRINT 'Stored Procedure: rf_user.dbo.pInsert_Staff'
SELECT @PrnLine = ' Return Code = ' + CONVERT(nvarchar, @RC)
мскл 2005
сборка 2.2.3 от магеника.
Есть у кого идеи в чем проблема?