Viewing 15 posts - 1 through 15 (of 1,482 total)
Thanks, yes, that is mostly I did.
When I asked the database model or Relationship from the vendor, they did not reply to me. I suppose they would not like us...
December 18, 2019 at 9:43 pm
Did set the isolation level is only available in Enterprise edition? I cannot find the information online.
Did that also require a reboot? I changed for my standard edition without...
December 16, 2019 at 5:55 pm
Did you ever find the solution, I have the same issue,
December 13, 2019 at 6:48 pm
Did you change the isolation level for reportserver db or reportServerTemp db?
We also have a lot of blocks and locks in the database.
December 12, 2019 at 5:00 am
I found out the account actually does have read access to the directory.
I tested to ask somebody not in our team but in same department to see if she can...
December 4, 2019 at 12:18 am
Thanks, figured out the access issue
November 26, 2019 at 9:24 pm
The strange thing is that the service account does not have access to a share, but it still can access the file.
November 25, 2019 at 9:45 pm
I will remember that if I just install SSMS, will also install sqlcmd separately.
November 13, 2019 at 12:25 am
Thank you, found it.
And I can run in sqlcmd mode in ssms.
But if I run in comand line, it still gives the error: sqlcmd is not recognized as an internal...
November 12, 2019 at 11:42 pm
Thanks, yes, I know I can do a separate download.
But just wonder if install SSMS by default also installs sqlcmd.
I had SSMS 18.4 installed (newest) , but apparently the sqlcmd...
November 12, 2019 at 11:09 pm
Thank you all
November 8, 2019 at 9:46 pm
No, I only reindex at weekend. And I don't see other jobs there.
I will change it to compressed backup to see if it makes a difference
November 8, 2019 at 8:12 pm
I am using maintenance plan to do full and differential backup.
And I see there is a differential backup file every week day.
November 8, 2019 at 7:58 pm
This is different.
The database in this case has little update daily, in fact nobody is using it.
November 8, 2019 at 7:45 pm
I know I can use the script, but SSMS is a tool that is used so often , you can also generate script from there.
But I just want to know...
August 21, 2019 at 4:51 pm