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?"

    Relevant Pages