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
SAP Adaptive Server Enterprise all versions
Keywords
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.