Viewing 15 posts - 241 through 255 (of 267 total)
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
All,
I changed both servers to Standard and it worked. It doesn't like, through SSMS at least, mixing developer and standard.
Thanks
September 12, 2017 at 9:48 am
Hello,
Thanks for your help. I only added one database and readable secondary is set to no.
Thanks
September 12, 2017 at 8:51 am
All,
We did need installation media from the reseller. Thanks for everyone's help.
Now I've hit a second problem. I have an Availability setup across two servers. I...
September 12, 2017 at 8:44 am
Both,
Thanks for your replies.
I had a look at the upgrade advisor but it requests a product key which we haven't been given so I was thinking...
September 11, 2017 at 1:05 pm
Hello,
Thanks for your help.
It might not have all the admin permissions but it should have enough to do this. I think the permissions required are the...
September 7, 2017 at 7:00 am
Viewing 15 posts - 241 through 255 (of 267 total)