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)))
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?
  +
   
   
Line 5: Line 6:
   
 
This issue might happen after installing some plugins onto AutoCount .
 
This issue might happen after installing some plugins onto AutoCount .
  +
   
   
Line 11: Line 13:
 
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>
   
   

Revision as of 08:54, 24 April 2018

Question: My server's SQL error log is growing bigger & bigger? Any way to stop it?


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