Viewing 15 posts - 436 through 450 (of 4,477 total)
You can check for what session is blocking the redo thread with the following - depending on what is blocking, sometimes you need to kill the session that is blocking:
July 18, 2019 at 2:30 pm
If it's only access, it is often done through the guest account which is enabled in master and should be kept enabled in master (as well as tempdb and msdb)....
July 18, 2019 at 1:17 pm
It can different things depending on whatever it is you are executing and from what database. Y0u'd also want to check what the user mapping is to that database -...
July 16, 2019 at 5:59 pm
If you are referring to the global variable in SSRS, that's the time the report starts to run so you wouldn't change that. If you want to change the format...
July 16, 2019 at 5:53 pm
1. Adding the with grant option allows the account to grant the permissions to another account. The account needs the permissions in the first place to grant to another account...
July 16, 2019 at 1:57 pm
It's a free added development tool that you can install - it replaced BIDS/Business Intelligence Studio Designer. You can download it from this link:
July 16, 2019 at 1:42 am
Thanks for posting back - glad it's all working for you now. I would guess it was adding the local accounts that made the difference. Some things are likely different...
July 12, 2019 at 5:44 pm
Could be related to the DBCC CHECKDB hidden snapshot. The database_id for it won't show up in sys.databases but the database id for the snapshot (if you see it when...
July 10, 2019 at 9:54 pm
It should work if the accounts are exactly the same. Windows doesn't change the domain names - it just looks at the user name and passwords. The other alternatives would...
July 10, 2019 at 8:07 pm
It's the secondaries agent account that need access to the logs, share where the logs are located. If it's shared out to A and A is the host, publisher then...
July 10, 2019 at 6:14 pm
In addition to checking the distinct database ids in sys.dm_os_buffer_descriptors, you may want to post the actual query you are using to see if anyone can reproduce the issue. Not...
July 10, 2019 at 5:49 pm
You would want to check the AlwaysOn_health extended events session. It's there for helping track down issues like this. With SQL Server 2014, You'd want to make sure to be...
July 9, 2019 at 10:31 pm
I would check to make sure all the servers in the mix are 2017 with CU6. And I'm not sure which port you are referencing with the port number but...
July 9, 2019 at 9:38 pm
I haven't done it but read a bit about it. You'd need a driver/provider that works with Big Query. You may want to check this:
July 9, 2019 at 6:01 pm
Get the row count after executing the SQL statement instead of before.
Sue
July 8, 2019 at 9:57 pm
Viewing 15 posts - 436 through 450 (of 4,477 total)