MOA VAT Return

Joined
Aug 8, 2011
Messages
1
Reaction score
0
Hi,

Trying to run a VAT return but keep getting "Database Timeout".

It's not a hardware problem as the server running the return is a 2 x 12 core 2.4 processor with 16 gb RAM running Windows Server 2003 AND SQL Server Professional.

I have been in contact with Mamut who gave me a few scripts to run to reduce the database size, however the VAT return still timesout. Been in touch with microsoft who will not help at all.

Has anyone else had this problem and how did you get round it? I can run the VAT100Liability report directly from SSMS by running the correct store proc, this takes about 25 hours, but thats kind of useless 'cus I can't seem to find the procedure to create the vat return from the VAT100Liability report.

I have a complete standalone test system so if anyone has any ideas I can test and report back.

Thanks

Simon
Tyretraders.com LTD
 
Joined
Jan 31, 2012
Messages
10
Reaction score
0
just wondering but on your server, how much of the 16gb is allocated to the sql server??
and how big is your database??
my database is getting on for 4gb and doesn't take that long...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top