Viewing 15 posts - 256 through 270 (of 287 total)
ChrisM@Work - Tuesday, October 10, 2017 8:19 AMLeft-pad the single-digit week numbers with '0'?
Thanks. That was the obvious solution I missed...
October 10, 2017 at 8:57 am
You are probably past this point so apologises for stating the obvious but just in case it's relevant:
If you are running the queries from a client it might...
October 4, 2017 at 12:05 pm
Hello,
Sorry, that wasn't intentional. I hadn't seen previous advice to disable SA so hadn't done it. I can see why it makes sense though so I will do...
October 2, 2017 at 2:33 pm
Jeff: Thanks.
Chris: Sorry I didn't see the notification for your post. Thanks, that's the account I thought it would use. Having re-checked the permissions that user doesn't have...
October 2, 2017 at 2:15 pm
Hello,
I think I figured it out (posted to help others rather than to 'show off'). Stuff has worked as follows:
It's taken the result returned from the...
October 2, 2017 at 1:33 pm
Thom, Luis,
Thanks for all your comments and help. I will take a look and see if I can figure it out myself. I'll post an update but I...
October 2, 2017 at 12:20 pm
Thom A,
Thank you for your help and apologises for not including the Sample Data. The below should be the required info:
October 2, 2017 at 10:55 am
All,
Apologises for not replying to this.
Thanks for your help.
It now works but unfortunately I don't have a complete explanation to help others. I'll share...
September 29, 2017 at 8:43 am
All,
The issue with an invalid login showing in the sql logs when the maintenance plan runs looks like it might be a bug https://social.technet.microsoft.com/Forums/en-US/83b3d647-7c66-4b9b-a63d-bdc2c39385f6/maintenance-plan-login-failed-for-user-sa-on-master-database?forum=sqlsecurity
Just looking...
September 29, 2017 at 7:52 am
Hello,
Thanks for your help.
That query shows a bad password time that matches the issue I had but lockout time of 1900-01-01 01:00:00.000. Weird.
I found one thing...
September 27, 2017 at 1:26 pm
All,
Just a quick post to say thanks for everyone's help.
The upgrade to a 2016 Basic Availability Group cluster has been done.
It would have been...
September 25, 2017 at 1:35 pm
Hello,
Sorry for my slow reply.
Both valid points. I tend to be lazy when I'm doing test queries and didn't think to correct it before posting, I'll...
September 21, 2017 at 1:06 pm
Hello,
Thanks. I found the issue about 10 minutes go (by doing similar to as you suggested) but had got chance to post yet.
In case it helps anyone else...
September 18, 2017 at 5:02 am
Hello,
Thanks for your help.
That's resolved that problem. Now it complains of 'Incorrect syntax near the keyword 'PIVOT'.' I'm still working on trying...
September 18, 2017 at 3:52 am
Viewing 15 posts - 256 through 270 (of 287 total)