Home Forums SQL Server 7,2000 Administration Problems accessing SQL Server when NT account has been renamed RE: Problems accessing SQL Server when NT account has been renamed

  • when you say object name did you check not only tables but also views and store procedures? Dont know if this will help but you can try it anyway

    --CREATE TABLE 'user_owner(lester)'

    IF NOT EXISTS (select name from sysobjects where xtype = 'U' and name = 'user_owner_lester')

    CREATE TABLE user_owner_lester

    (Name varchar(50), uid int, DB_Name varchar(80),UserName varchar(50),Object_Type varchar(50))

    INSERT INTO user_owner_lester exec sp_msforeachdb

    'use ?

    select sysobjects.name as ''Object Name'' , sysobjects.uid as ''User ID'',db_name() as ''Database Name'',

    sysusers.name as ''User Name'',

    CASE sysobjects.xtype

    WHEN ''V'' THEN ''Views''

    WHEN ''U'' THEN ''Tables''

    WHEN ''P'' THEN ''Stored Procedures''

    END as ''Object Type''

    from sysobjects,sysusers where sysobjects.uid = sysusers.uid

    and sysobjects. xtype in (''U'',''V'',''P'') and

    sysobjects.uid in (select uid from sysusers where name not like ''db_%'' and name not in (''guest'',''dbo'',''public''))

    order by db_name(),sysobjects.xtype

    '

    Select Name as 'Object Name', uid as 'User ID', DB_Name 'Database Name',

    UserName as 'User Name', Object_Type as 'Object Type'

    From user_owner_lester order by db_name,object_type

    DROP TABLE user_owner_lester

    "-=Still Learning=-"

    Lester Policarpio