Key DBA (8/28/2008)
I get the following error when running the query against one of my servers:Msg 102, Level 15, State 1, Line 14
Incorrect syntax near '-'.
(260 row(s) affected)
(260 row(s) affected)
... I have a user named 'dotnet-apps' that seems to be causing the problem. The result set still displays all the other users, just not the 'dotnet-apps' account.
I am trying to test this scenario with a hypenated username, but SQL Server doesn't let me create it.
CREATE LOGIN shiva-test
WITH PASSWORD = 'test';
how were you able to create it?
Kindest Regards,
Shivaram Challa
(http://challa.net - Home of the "Excel to CSV converter & Browsepad applications".)
Forum Etiquette: How to post data/code on a forum to get the best help[/url]