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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2008-07-15 : 05:22:21
|
| Can you please let me know why I get this error?sql:declare @login varchar(50)declare @DomainName varchar(50) set @DomainName = 'myDomainName'set @login = @DomainName + '\myUsername'CREATE LOGIN [@login] FROM WINDOWSerror:'@login' is not a valid Windows NT name. Give the complete name: <domain\username>.Thanks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-07-15 : 05:29:52
|
[code]declare @login varchar(50)declare @DomainName varchar(50)set @DomainName = 'myDomainName'set @login = @DomainName + '\myUsername'declare @sql varchar(8000)set @sql = 'CREATE LOGIN ' + quotename(@login) + 'FROM WINDOWS'exec (@sql)[/code]
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
|
|
|
login