Viewing 15 posts - 1 through 15 (of 287 total)
Hello,
Thanks for your help. I hadn't seen that and it it looks interesting. I will take a look.
I didn't specify when I created my post but I was more thinking...
April 17, 2024 at 10:27 am
Thanks for your reply.
All: Thank you for your help. I put in some code to update the stats and it seems to be solve the issue consistently and now I...
April 16, 2024 at 3:31 pm
I've discovered that the table is updated overnight and the issue re-occurs overnight.
If I run the code in the morning then it takes too long to complete. If I then...
April 8, 2024 at 3:33 pm
All,
Thanks for your help.
I updated the statistics today and it seems to have fixed the issue. I will retry the code over the next few days to see if it...
March 28, 2024 at 5:46 pm
All,
Thank you for your replies and suggestions. Sorry I haven't been back to this topic, I've had some other unplanned things to sort out. When I get back to it,...
March 23, 2024 at 10:31 am
Hello,
Thank you for your help.
Are both servers running the same SQL Server version?
Are both databases using the same compatibility level?
Are both databases using the same transaction isolation level?
Are both...
March 15, 2024 at 10:27 am
All,
Firstly apologies for posting a question and not replying. That wasn't my intention. Some unexpected issues took my time.
The reason for renaming is that the backup will be picked up...
September 25, 2023 at 12:29 pm
All,
Thank you for your help and apologies for not replying. Another issue has taken my attention and I haven't had chance to reply.
I will reply to everyone's questions soon, probably...
September 15, 2023 at 10:59 am
All,
Thank you for your help.
I was able to capture all the information I need using Extended Events.
July 6, 2023 at 7:13 pm
Just an update in case it's useful to anyone:
Scripting the database doesn't show any relevant permissions.
If you unversion the table the insert permission isn't shown in SSMS. If you re-version...
June 7, 2023 at 6:17 pm
All,
Thanks for your replies.
Scripting out the database is a good idea, I'll try that.
I'll carry on investigating and if I find an answer or anything else that might be useful...
May 10, 2023 at 7:10 pm
Sorry for taking so long to reply.
I don't get an error from that command.
I did some testing on a test system. I created a table as follows:
CREATE...
May 9, 2023 at 6:32 pm
I haven't tested this but maybe it requires one of the SSIS permission roles? I think this is the relevant documentation https://learn.microsoft.com/en-us/sql/integration-services/security/integration-services-roles-ssis-service?view=sql-server-ver15
As I said not tested and some...
April 29, 2023 at 2:44 pm
Sorry for my slow reply.
I created the user from login. At the server and database level they are only in the public role and I can't see anything relevant allocated...
April 26, 2023 at 2:17 pm
I am not 100% sure but I think the problem might be as follows:
The log file from the primary server isn't applying to the secondary server which will cause the...
April 11, 2023 at 5:49 pm
Viewing 15 posts - 1 through 15 (of 287 total)