Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sapator
Constraint Violating Yak Guru
462 Posts |
 Posted - 2010-12-02 : 01:07:57
|
| Strangely, i cannot find enough info on the net.What i want to do is of course use this sp.So we have 3 values to pass:@ApplicationName nvarchar(256),@UserNames nvarchar(4000),@RoleNames nvarchar(4000)...My main focus is on @UserNames.Now the questions:1)@usernames, i will pass an @arrayofvalues (like user1,user2,user3)or i would pass values one by one with a loop (yikes, hope not)?2)Can i maximize the nvarchar @usernames?Will it,well,explode?3)Has anyone really used this without relying on the asp interface?I want to make an sql job for quick role assignment.Thanks, hope it isn't to extreme of a question. |
|
|
|
|
|
aspnet_UsersInRoles_RemoveUsersFromRoles