Troubleshooting: SQL Log Files keep on Growing: Difference between revisions
Content added Content deleted
m (Protected "Troubleshooting: SQL Log Files keep on Growing" ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite) [Delete=Allow only administrators] (indefinite))) |
No edit summary |
||
(2 intermediate revisions by one other user not shown) | |||
Line 1: | Line 1: | ||
'''Question''' |
'''Question:''' My server's SQL error log is growing bigger & bigger? Any way to stop it? |
||
<b>Version:</b> 1.8 / 1.9 / 2.0 |
|||
Line 5: | Line 7: | ||
This issue might happen after installing some plugins onto AutoCount . |
This issue might happen after installing some plugins onto AutoCount . |
||
<u><b>Solutions:</b></u> |
<u><b>Solutions:</b></u> |
||
1.Login to SQL Management Studio and run script below |
1.Login to SQL Management Studio and run script below. |
||
<span style="color:red">ALTER AUTHORIZATION ON DATABASE::[DatabaseName] TO SA;</span> |
<b><span style="color:red">ALTER AUTHORIZATION ON DATABASE::[DatabaseName] TO SA;</span></b> |
||
By:Jun Tat 170615; P170801 |
By:Jun Tat 170615; P170801 |
||
{{NavigateForUser}} |
{{NavigateForUser}} |
Latest revision as of 02:22, 24 February 2020
Question: My server's SQL error log is growing bigger & bigger? Any way to stop it?
Version: 1.8 / 1.9 / 2.0
Possible Reason:
This issue might happen after installing some plugins onto AutoCount .
Solutions:
1.Login to SQL Management Studio and run script below.
ALTER AUTHORIZATION ON DATABASE::[DatabaseName] TO SA;
By:Jun Tat 170615; P170801
AutoCount Accounting 2.0 & 2.1
|
AutoCount Accounting 1.8 / 1.9
|
AutoCount Payroll
|
AutoCount POS
|
AutoCount On The Go
|
AutoCount Accounting Plug-In Documentations
|