Re: sp_addalias bug?

From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 02/05/04

  • Next message: Dan Guzman: "Re: SQL 6.5 sa Password, how to change?"
    Date: Wed, 4 Feb 2004 22:35:36 -0600
    
    

    According to the Books Online, the specified login can be a Windows user but
    there is no mention that a Windows group can be specified. It looks like
    this is expected behavior.

    -- 
    Hope this helps.
    Dan Guzman
    SQL Server MVP
    "Derek" <anonymous@discussions.microsoft.com> wrote in message
    news:a23401c3eb4e$a5f18070$a501280a@phx.gbl...
    > I need to alias an NT group as dbo on SQL Server 2000 SP3.
    > The group name has spaces in it. When I run
    > sp_addalias 'CUFLA\IS Domain Analyst', 'dbo'
    > I get "Windows NT user or group 'CUFLA\IS Domain Analyst'
    > not found. Check the name again.
    > Yet I copied the name from running sp_helplogins. Ive
    > tried quotes, brackets ......
    >
    

  • Next message: Dan Guzman: "Re: SQL 6.5 sa Password, how to change?"