Viewing 15 posts - 1 through 15 (of 52 total)
ScottPletcher,
Thank you. This is exactly what I need.
August 26, 2021 at 9:09 pm
The issue kept happening. The user was using the front-end Access without any issue, and then suddenly this error message appeared. The user had to restart the workstation to get...
November 16, 2016 at 1:39 am
It looks like a SQL Server hiccup. After I restarted the SQL Server service I was able to send out a test email with attachment.
October 15, 2016 at 9:37 pm
The service account was "Local System", which I think can register its SPN automatically. I do not know how to check its SPN. So I changed the service account to...
October 15, 2016 at 9:35 pm
Thanks for the quick reply and right-on explanation.
The link is a great resource.
July 27, 2016 at 2:47 pm
VastSQL,
Thanks for the great tip. I checked the sql server log and it shows a fatal exception with a SQL Dump.
"SqlDumpExceptionHandler: Process 2396 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL...
July 15, 2016 at 9:41 am
Yes. I meant SKIP.
I tried the FORMAT option with a new file path but got the same error.
July 8, 2016 at 2:38 pm
One minor correction: I had to restart the SQL Server Service to resolve the issue temporarily. I did not restart OS.
It looks like a cycle of:
1. restarting the service;
2. backup...
July 8, 2016 at 2:02 pm
The backup drive has over 1T free space, while the total size of compressed bak files during a daily backup is less than 40G. So it is not a space...
July 8, 2016 at 1:48 pm
Thank you all for the quick responses.
August 24, 2015 at 11:45 am
Scott,
My test showed that , without the grant on create table/create procedure/create view/create function, the user cannot create any objects under the rpt schema.
I also tested "Grant Alter to the...
July 14, 2015 at 9:28 am
Martin,
Thanks for the response.
I do not think there is much performance difference between count() and sum() either.
I do need an additional measure - Distinct Count of Member ID. If...
July 6, 2015 at 8:22 am
It looks like a buffer memory issue.
Here is an article talking about the same problem.
http://sqlserverscribbles.com/2013/12/03/ssis-package-fails-with-out-of-memory-errors/
June 19, 2015 at 8:31 am
You may use "Who Is Active" script.
http://sqlblog.com/files/folders/release/entry35240.aspx
Create an agent job (schedule for every 5 minutes or any frequency you need), use the code from the script to get...
June 17, 2015 at 12:43 pm
Which task failed, the Data Flow Task or the Send Mail Task?
June 17, 2015 at 8:57 am
Viewing 15 posts - 1 through 15 (of 52 total)