Dynamic Script To Add Domain Login Accounts 2000/2005

I'm attempting to write a script that I can execute accross 30 servers that will create a domain login and subsequently grant access to said account on all databases per server. The only problem that I'm running into is trying to dymanically create the login. Example source is below.


declare @sql varchar(1000)

declare @loginname varchar(50)

select @loginname = 'DOMAINaccountname'

set @sql = 'if not exists (select * from master.dbo.syslogins where name = N' + char(39) + 'DOMAINaccountname' + char(39) + ')' + char(10) + char(13)

set @sql = @sql + 'begin ' + char(10) + char(13)

set @sql = @sql + char(9) + 'exec master.dbo.sp_grantlogin ' + quotename(@loginname)

print @sql

exec (@sql)


Here is the generated output and the error. Any suggestions would be appreciated.



if not exists (select * from master.dbo.syslogins where name = N'DOMAINaccountname')

begin

exec master.dbo.sp_grantlogin [DOMAINaccountname]

Msg 102, Level 15, State 1, Line 3

Incorrect syntax near 'DOMAINaccountname'.