I've attached the complete dbcc results.

for the index with id 22, i can't find which one this is.

SELECT name from sysindexes where id = 1591012749 and indid = 22;

=> no...

Changing the database ownership to 'sa' fixed it, the dbo account at the database level automatically mapped to sa.

The user account we wanted to remove were no longer mapped...

This is not the database owner, another account is (but not sa).

I will try to change ownership to sa.

I have attached both the server-level and database-level properties of the login.

thank you

The output for

DBCC TRACEON (3604);

GO

DBCC DBINFO ('TRACKIT80_DATA2007');

GO

is:

DBINFO STRUCTURE:

DBINFO @0x000000004329E480

dbi_dbid = 10 ...

The result for:

USE [your_database];

GO

SELECT SUSER_NAME(principal_id)

FROM sys.database_principals

WHERE name = 'dbo';

GO

is 'sa'

yes, i tested it first, and then implemented it in production -- haven't heard any issues [yet].

thanks!

unfortunately i don't know the history of this db.

i was trying to recreate this scenario on a test server but i was unable to map/alias a user as dbo since...

thanks!

thank you, that clarifies it a lot!

what would be a healthy value to start off with?

Of the 12 GB RAM on the system, 10 GB is set as the max size for SQL Server.

From my understanding, the CLR functions are using memory from the 2...

hi,

Most of the 'marked for unload due to memory pressure' articles i see point to use of CLR functions. would this have eventually caused the server itself to run out...

a follow up question -- the version and the edition of the principal and mirror server is the same, does the Service Pack also need to be the same?

or could...

Thanks Lynn!