Soemthing like this
Declare @SomeUser Varchar(128)
set @SomeUser = 'FredtheBed'
EXEC sp_addlogin @SomeUser, 'food', 'isc_clients'
>Is there a way to accomplish something like:
>
>
>CREATE PROCEDURE Secure.dbo.AddUser
>@SomeUser Varchar(128)
>
>
>CREATE LOGIN @SomeUser with password = '93846756', default_database='Secure'
>create user @SomeUser
>
>
>I have found a post that suggests a building string and using EXEC. Is there some other way? If not, I'll deal.
>
>TIA
>Richard