I have an application and I want to add/edit/del Logins and Users in Sql
Server 2005 through the application, can I do it?  I am using windows
authentication.  Currently I call a stored proc that I try to pass a login
and it doesn't work.  For example this is my Delete.

ALTER PROCEDURE [dbo].[usp_UserRoleDelete]
    -- Add the parameters for the stored procedure here
    @LoginName nvarchar(50)
AS
BEGIN

    SET NOCOUNT ON;
    Begin
        --Drop the login which drops the user?
        Drop Login [@LoginName]

    End
END

When it runs I get you can't add a login called @LoginName.  If I take the
brackets off it will not compile.  Can i do what I'm trying to do?  I've also
tried using sp_DropLogin w/o success.  I did see somewhere in documentation
for the sp_dropLogin "sp_droplogin cannot be executed within a user-defined
transaction."  There is nothing about the in the Drop Login documentation.  
Is this the problem?

Thanks in advance,
Greg P.