Re: sp_addalias bug?
From: Dan Guzman (danguzman_at_nospam-earthlink.net)
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" <email@example.com> wrote in message news:firstname.lastname@example.org... > 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 ...... >