Alter Procedure admNewUser @login sysname, @pass sysname
As
set nocount on
IF EXISTS(SELECT name FROM dbo.sysusers WHERE issqluser= 1  AND name=@login)
   BEGIN
	Declare @usr sysname
	SET @usr=@login+'_new'
	IF NOT EXISTS(SELECT name FROM dbo.sysusers WHERE issqluser= 1  AND name=@usr)
		EXEC sp_grantdbaccess @login, @usr
	EXEC sp_addrolemember 'm_user', @usr
   END
ELSE
   BEGIN
	EXEC sp_grantdbaccess @login, @login
	EXEC sp_addrolemember 'm_user', @login
   END
return

{ call admNewUser(?, ?, ?, ?) }

Set cmd = Nothing