解除TFS的License组中的用户数已达到最大用户数限制！

时间：2010-11-01 来源：hijarry

1 USE [TfsIntegration]
2 GO
3
4 DECLARE @LicensedUsersSID VARCHAR(100), @MemberSID VARCHAR(100), @MemberName VARCHAR(100);
5
6 SET @MemberName = 'tfstestuser';
7
8 SELECT @LicensedUsersSID=[sid] FROM [TfsIntegration].[dbo].[tbl_security_identity_cache]
9 WHERE ([display_name]=N'Team Foundation Licensed Users') AND (deleted=0);
10
11 SELECT @MemberSID=[sid] FROM [TfsIntegration].[dbo].[tbl_security_identity_cache]
12 WHERE ([display_name]=@MemberName) AND (deleted=0);
13
14
15 INSERT [TfsIntegration].[dbo].[tbl_security_membership_cache] ([container],[member]) VALUES (@LicensedUsersSID,@MemberSID);
16 INSERT [TfsIntegration].[dbo].[tbl_gss_group_membership] ([parent_group_sid], [member_sid], [last_update]) VALUES (@LicensedUsersSID, @MemberSID, getdate());
17
18 GO
19

相关阅读更多 +