You can find the sid with:-
select * from sys.sysusers
where
    [name] like 'domain\domainuser'

Thank you for thisd tool Carolyn.

Why does the stored procedure usp_RefreshDeadockObject search for "objectlock lockPartition=0" please, and why does this not appear in my SQL Errorlog with the required trace...

Is there anything wrong with this string on a connection to a SQL2014 database please?

--network protocol: TCP/IP

set quoted_identifier on

set arithabort off

set numeric_roundabort off

set ansi_warnings on

set ansi_padding on

set ansi_nulls on

set concat_null_yields_null...

Thank you for the link John Walker but I am looking specifically for the connection method information I requested expansion of.

Please could you expand "...it was using several methods for connecting to the DB. One of these methods, passed the username as part of its windows authentication string...". I am...

SQL Maintenance Plans have an option "History Cleanup Task"."SQL Server Agent job history" that I assume cleans up job history in a supplied fashion.

I have just experienced this error and it turned out to be some kind of disk corruption. We had a dead disk in a RAID 5 array. After replacement and...

Check the "Automatically set I/O affinity mask for all processors" in your server properties. We had unselected this to reduce processors for licensing, and the maintenance plan failed the following...