Difference between revisions of "Troubleshooting: SQL Log Files keep on Growing"

From AutoCount Resource Center
Jump to navigation Jump to search
m (Protected "Troubleshooting: SQL Log Files keep on Growing" ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite) [Delete=Allow only administrators] (indefinite)))
 
(2 intermediate revisions by one other user not shown)
Line 1: Line 1:
'''Question''': My server's SQL error log is growing bigger & bigger? Any way to stop it?
+
'''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



Go to menu

IconAcc20.PNG AutoCount Accounting 2.0


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS


Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations