DROP INDEX PrincipalLoginName ON [dbo].[Principal]
ALTER TABLE Principal ALTER COLUMN LoginName nvarchar(255)  COLLATE DATABASE_DEFAULT
CREATE NONCLUSTERED INDEX PrincipalLoginName ON [dbo].[Principal]
(
            [LoginName] ASC,
            [Type] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
