Viewing 15 posts - 136 through 150 (of 984 total)
Have you recently patched the server?
May 9, 2018 at 9:19 am
A quick skim of the https://www.hmailserver.com/documentation/latest/?page=system_requirements documentation indicates that this product is only supported on SQL Server up to SQL Server 2016.
As mentioned above, you might have better...
May 9, 2018 at 9:10 am
Has the underlying storage changed? Is your storage experiencing other problems?
Are you backing up locally or remotely? If to a remote location, has your network config changed?
May 9, 2018 at 2:05 am
M'colleague is wise.
Here - have some code.
DECLARE @dt VARCHAR(20) = '20180426 112500';
SELECT @dt AS YourString,
STUFF(STUFF(@dt, 14, 0, ':'), 12, 0,...
April 27, 2018 at 4:29 am
April 17, 2018 at 10:20 am
April 12, 2018 at 7:32 am
Make the first step of the SQLAgent job a query against sys.fn_hadr_is_primary_replica to see if the database hosted locally is the primary or the secondary, and then use...
March 23, 2018 at 3:07 am
Sounds like a file permissions problem. Check that the SQL Server service account has the appropriate consistent permissions across all those files.
March 14, 2018 at 5:44 am
William Rayer - Tuesday, March 13, 2018 5:29 AM"lakhs of tables, stored procedures"What are lakhs of tables?
It's an Indian thing. one lakh...
March 13, 2018 at 6:39 am
If you follow the steps to create a scheduled task to cycle the error log every day, and then set SQL Server to retain only ten logs, then that'll give...
March 2, 2018 at 6:01 am
Which antivirus product is this?
There's some general advice from MS about installing/configuring AV software to run on SQL Servers at https://support.microsoft.com/en-us/help/309422/how-to-choose-antivirus-software-to-run-on-computers-that-are-running
You might also want to check...
February 26, 2018 at 5:11 am
(1) Remove one of the )s from the last line.
(2) that last "FROM SOLICIT.gtm_doc" bit - does that belong to the SELECT MAX(D.sent_date) bit? because you've already got...
February 23, 2018 at 7:38 am
The .mdf file that was mailed to you... what version of SQL Server was that from? If it was from a later version, then you won't be able to attach...
February 21, 2018 at 5:32 am
Viewing 15 posts - 136 through 150 (of 984 total)