Problem Granting Permission to Usernames containing / or . ???



Can someone explain why I am unable to do this now on my SQL Database.
Suspect it is some settings / collation or the like but when I say

GRANT EXECUTE ON functionname TO DOMAIN\Fred.bloggs

I get Incorrect syntax near \

I have tried dynamic sql and performing replace strings using CHAR() etc.

I am sure I used to be able to do this kind of thing without syntax errors?

Has anything changed in SQL??? Or am I missing something?

HELP! Please

--
Steve G
.



Relevant Pages

  • Re: Yet another SQL Express SP2 on Vista Problem...
    ... default collation is dependent on your regional settings ... Microsoft SQL Server databases. ...
    (microsoft.public.sqlserver.setup)
  • Re: DRW issues - sql collation
    ... 'Collation designator' settings during setup (or with rebuildm), ... > which sql installation settings will cause tempdb to match the sms db ...
    (microsoft.public.sms.admin)
  • Re: Parameter for Stored Procedure
    ... Incorrect syntax near '@ClientDBName'. ... FILENAME = N''C:\Program Files\Microsoft SQL ... MAXSIZE = UNLIMITED, ... FILEGROWTH = 1024KB) ...
    (comp.databases.ms-sqlserver)
  • Re: DRW issues - sql collation
    ... which sql installation settings will cause tempdb to match the sms db ... collation, then use rebuildm or install sql with that collation on another ... box and point sms to that db. ...
    (microsoft.public.sms.admin)
  • strange errors in execute sql task
    ... while executing "execute sql" tasks. ... Incorrect syntax near "1" ... uninstalling & installing sql server didn't help. ...
    (microsoft.public.sqlserver.dts)