We are about to upgrade to GP 2010 R2 but are getting the error below when trying to post a purchasing batch. Please help.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Procedure or function IVPurchaseReceiptGetNextAvailOrd has too many arguments specified.
Hello all, I have a third party payment web site. The problem is that when a customer logs in to pay a bill everything is fine until the payment is processed there is no confirmation page (HTTP 500 error displays). On the elmah log it displays a SQL permissions error. I tried giving the web user...
I'm an accidental DBA. My production environment is on a standard verison of Sql Server 2008. I ran the following query:
SELECT name, log_reuse_wait_desc FROM sys.databases
All my databases are ok and go between Log Backup and Nothing, except for the master database. I have check several times...
It seems on the rebbot of a server a trace had started and the audittrace*.trc files generated brought the drive space down to 0KB and stopped the Server. I have tried taking the trace off with this code
SELECT * FROM ::fn_trace_getinfo(default) WHERE property = 2;
DECLARE @TraceID int
SET...
My accounting department ran their end of the month Aging report and the GL as usual. This time the aging report has a balance of $35 more than the GL. I'm having a bear of a time finding this, if anyone can point me in the right direction I would appreciate it.
When staff trys to logon they continue to get this error
Logon failed. 28000:[Microsoft][ODBC SQL Server] Logon failed for user 'accruser'. I can login as SA, and have even created a new user to access the Crystal Report and still nothing. This report is tied to an older version of GP which is...
I have been staring at this code for so long I don't even know what to do anymore. I need to automate several reports for the fiscal year which is 9/30-10/1 (example : 9/30/09-10/01/2010). This is what I have so far, any suggestions/guidance would be appreciated.
-- Insert statements for...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.