Symptom
Using "create login" command or executing sp_addlogin procedure:
1> set quoted_identifier on
2> go
1> create login O'name with passoword "password"
2> go
Msg 105, Level 15, State 2:
Server 'ase16sp04pl04', Line 1:
Unclosed quote before the character string 'name with passoword "password"
'.
Msg 102, Level 15, State 181:
Server 'ase16sp04pl04', Line 1:
Incorrect syntax near 'name with passoword "password"
'.
1>
2>
3> create login "O'name" with password "password"
4> go
Msg 203, Level 16, State 3:
Server 'ase16sp04pl04', Line 3:
The name 'O'name' is not a valid identifier.
1>
Read more...
Environment
SAP Adaptive Server Enterprise
Product
Keywords
Error, Msg, 102, 203, create login, sp_addlogin, quoted identifier, syntax error, apostrophe, ', Incorrect syntax, valid identifier, name , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
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