The output for
DBCC TRACEON (3604);
GO
DBCC DBINFO ('TRACKIT80_DATA2007');
GO
is:
DBINFO STRUCTURE:
DBINFO @0x000000004329E480
dbi_dbid = 10 dbi_status = 65544 dbi_nextid = 1933301997
dbi_dbname = TRACKIT80_2007 dbi_maxDbTimestamp = 1129100 dbi_version = 655
dbi_createVersion = 539 dbi_ESVersion = 0
dbi_nextseqnum = 1900-01-01 00:00:00.000 dbi_crdate = 2011-05-11 08:58:49.677
dbi_filegeneration = 0
dbi_checkptLSN
I presume this was a SQL 6.5 db originally?
I am logged in with a sysadmin role (not 'sa') so "SELECT USER_NAME();" is dbo.
In Enterprise Manager, when I expand this database, go to Security, I do not see the login of the user that we want to drop.
But when i select the properties of dbo, it shows that the login name is the user account to be dropped.
It is also a member role of db_owner.
Any ideas how to remove the mapping?
thank you