Viewing 15 posts - 1 through 15 (of 146 total)
Yes, your query should show Kerberos connections if they are using them. To check if the spn has been set up, you could do two things:
Firstly, from a command...
November 11, 2016 at 2:52 am
If you're using the search tool on the New Login screen, it won't find the managed service account and you will get this error - I take it that is...
November 10, 2016 at 2:03 am
No, the account cannot be shared for another sql service on another server. The account is tied to the server. Even if you were using a normal service account,...
November 9, 2016 at 2:24 am
I've used them since SQL 2012. The only issues I had is with setting up kerberos delegation, but this site explains how to get it working:
November 8, 2016 at 9:23 am
Excellent. That works fine. Just what I need.
August 4, 2016 at 6:22 am
Perfect, thank you.
August 1, 2016 at 5:15 am
If anyone is interested, this is the script I wrote to read the data. This reads the input of one column, reads the first row of the data and...
May 5, 2016 at 8:20 am
I asked a question, but I think I've found the solution... ignore me!
May 4, 2016 at 3:45 am
Excellent. Thank you. That makes sense. I'll look at the asynchronous scripting and see if I can get it working. Thanks.
May 3, 2016 at 9:28 am
March 17, 2016 at 8:42 am
Jacob Wilkins (3/17/2016)
John Mitchell-245523 (3/17/2016)So you want to match every job with every status? Just use a CROSS JOIN.John
John Mitchell-245523 (3/17/2016)
To elaborate on this, it sounds like you're looking for something...
March 17, 2016 at 8:27 am
I thought that, and it works for where there is a job with no status, but where a job has one or two status's then it joins the wrong status...
March 17, 2016 at 8:26 am
If you have Redgate SQL Monitor, you could use my custom metric:
Even if you dont have sql monitor, I am sure you could adapt it to...
February 12, 2016 at 9:19 am
I'll have a dig around and see what I can come up with.
February 9, 2016 at 9:45 am
Maddave I'm curious about this issue you saw. I would expect that an entry wouldn't be written to backupset until the backup actually completed? Or was...
February 5, 2016 at 7:53 am