Viewing 8 posts - 1 through 8 (of 8 total)
You can find the sid with:-
select * from sys.sysusers
where
[name] like 'domain\domainuser'
September 18, 2018 at 8:17 pm
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...
December 19, 2016 at 2:57 pm
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...
February 8, 2016 at 8:00 pm
Thank you for the link John Walker but I am looking specifically for the connection method information I requested expansion of.
February 5, 2016 at 11:19 am
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...
February 4, 2016 at 9:06 pm
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.
March 29, 2015 at 7:20 pm
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...
March 8, 2011 at 6:26 pm
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...
March 29, 2009 at 9:17 pm
Viewing 8 posts - 1 through 8 (of 8 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy