Viewing 15 posts - 31 through 45 (of 48 total)
If you have to set anything like encrypt=false or TrustServerCertificate=True to get you app working, your sql server is definitly configured to use a certificate. Maybe it's not set to...
March 3, 2023 at 10:32 am
No need for a large sql statement. Just open the properties of the job and check which database is uses. Easy peasy.
March 3, 2023 at 10:24 am
Hello @bobrooney.81
the solution to your problem is quite easy: Start thinking by your self. Then switch to https://ola.hallengren.com. There you find every necessary information about your problem.
But hey: It's far...
November 25, 2022 at 9:43 pm
Hello Chitown,
1. look at the SQL Server Errorlog,
2. look at the Windows Eventlog,
3. look at the application server and the application itself.
4. Execute (if possible) the statement of the job...
July 29, 2022 at 3:49 pm
Hi there,
I can recommend these approaches to migrate databases to new storage.
https://www.sqlphilosopher.com/wp/?s=filegroup
and
https://www.bobpusateri.com/archive/2013/03/moving-a-database-to-new-storage-with-no-downtime/
February 24, 2021 at 7:25 am
Hi Rod,
i would rebuild the system databases with the setup command.
Regards
marcus
October 13, 2020 at 4:58 am
Just to let you know that it still shows 1105 despite that there is enough space left. Really enough.
October 11, 2020 at 11:18 am
Hi Thomas,
just checked this server. It's set to high performance in the BIOS and in Windows.
March 11, 2020 at 5:33 am
Hi deubel_m,
I was also surprised to see this bug. This has been confirmed by Microsoft and a fix is on the way (no ETA has been stated). Note...
September 23, 2019 at 11:58 am
In addition I get the error when I want to change the default language saying "Login failed for user 'xxx'. Reason: Failed to determine the language and date format while...
September 23, 2019 at 8:22 am
Service account of instance has access to the share?
Yes, definitly. The service accounts have full control on the share and has full control NTFS permissions.
Creating dbs on the share...
May 28, 2019 at 2:24 pm
Finally I found the problem and solution.
The reason why the processor pane of the activity monitor was greyed out was:
the remote registry service has to run. On my cluster it...
April 12, 2019 at 6:14 am
As per this link, that login needs sufficient READ access...
March 26, 2019 at 2:09 am
March 25, 2019 at 1:13 am
Hi there,
I have a possible solution. Found this post about the performance counters (CPU Usage in SSMS is just an performance counter) https://social.technet.microsoft.com/Forums/windowsserver/de-DE/cb66af1c-0e3f-440b-9480-b94b4b8c4c38/event-id-2004-error-source-perfnet?forum=exchangesvradmin
I havn't tried it yet....
March 24, 2019 at 11:21 pm
Viewing 15 posts - 31 through 45 (of 48 total)