Symptom
- Using CREATE LOGIN command or executing sp_addlogin procedure
- Error 102 when "quoted identifier" option is off
1> set quoted_identifier off
2> go
1> create login a-b with password "password"
2> go
Msg 102, Level 15, State 181:
Server 'ase_1604', Line 1:
Incorrect syntax near '-'.
- Error 203 when "quoted identifier" option is on
1> set quoted_identifier on
2> go
1> create login "a-b" with password "password"
2> go
Msg 203, Level 16, State 2:
Server 'ase_1604', Line 1:
The name '"a-b"' is not a valid identifier.
Read more...
Environment
SAP Adaptive Server Enterprise
Product
Keywords
error 102, error 203, create login command, sp_addlogin procedure, quoted identifier option, syntax error, hyphen in login name, period in login name, login name restriction, feature enhancement CR 829738, login name validation, incorrect syntax , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview