Re: sp_change_users_login use after restore

From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 12/07/03 

Date: Sat, 6 Dec 2003 19:56:36 -0600

To add to the other responses, perhaps the login us a member of the sysadmin
role on the new server. In that case the login will will be 'dbo' in the
database instead of the normal userid and will need to qualify the table
name. 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"Ken" <raidken@yahoo.com> wrote in message
news:f1d5649d.0312061424.49641d12@posting.google.com...
> Hello,
>
> I restored a sql server 2000 database to a new server. After the
> restore, I used sp_change_users_login to correct orphaned users.
>
> Here's the problem, now I am having to prefix all objects with the
> owner name.
>
> Even though I am logged in as the user who owns the employee table.
> select * from employee ---does not work
> select * from <owner>.employee -- works
>
> The sysxlogin table and the sysuser table have the identical SID for
> the user, so I would assume SQL Server should be able to associate the
> database user with the login name.
>
> Any help will be highly appreciated.
>
> Thanks
>
> Ken

Relevant Pages

  • RE: WSS install locked into MSDE DB - Can not install for SQL Serv
    ... For the MASTER database ... Althought we change the Configuration Application pool several times ... interface BUT they appear to be MSDE databases and not SQL Server databases. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: How to Replicate an SQL Server 2000 Database
    ... actual server name) enterprise manager should associate the database with the ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: Install MSDE w/ MSDE Depl.Toolkit. What permissions when using Win Auth?
    ... I created a login using Enterprise Manager on SQL Server on my server. ... Database Access tab I ticked the tick box for the database that I ... Now when my user installed the MSDE database on his machine locally, ...
    (microsoft.public.sqlserver.msde)
  • Re: SQL 2005 Best Practice vs SQL 2000: Application Files Separate from data (and log) files
    ... I have had quite a number of clients that used a SAN for a database server and suffered significant performance problems because their underlying SAN infrastructure was a huge stripe across many drives. ... By application files I mean the binn folder which contains the sql server executable among other things. ...
    (microsoft.public.sqlserver.setup)
  • Re: Database setup with Windows Installer
    ... give that group permissions to your server and DB). ... many people can share the same login (but you won't be able ... connect to an instance of SQL Server using SQL Server Authentication ... > I've got an application that requires a SQL Server database. ...
    (microsoft.public.dotnet.framework.setup)