Search results for query: *

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.

Thank you for the suggestions. There is a stored procedure that the trace points to. this stored procedure adds the payment to the CSM. I am again working with the developers today on reintalling the customer web payment software on a test server and attempting to make payments while running a...

Sorry about that. The Elmah is stating an error of: System.Data.SqlClient.SqlException (0x80131904): The User does not have permission to perform this action. The developers have looked through the stored procedure and nothing within the sp is causing this permissions issue.

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...

You can do a bcd through the cmd prompt, here is a link on how to use it http://www.techrepublic.com/blog/datacenter/how-do-i-use-bcp-in-sql-server/319. That or if you just need a few rows you can write an insert statement. If you want to create a new table and you have a backup of the...

Have you tried to create a DAC Connection? Here is a link that tells you how to do it through the cmd prompt. http://msdn.microsoft.com/en-us/library/ms189595.aspx

Books Online has a lot of good information. Also there is a very detailed book available on Amazon called Microsoft SQL Server 2008. I also have found two other books that are helpful which are SQL Server 2008 Administration, and Professional SQL Server 2008 Internals and Troubleshooting. You...

You could also create a policy that has a @IsDatabaseSnapshot condition which will verify whether your database it is a snapshot :)

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...

Thanks for all your help George. It seems that after I had run EXEC sp_configure 'c2 audit mode', '0'; RECONFIGURE; EXEC sp_configure; with no change on the run_value, I waited until after hours and just restarted the SQL Server services and everything took effect. So if in doubt, restart.

The enable C2 audit tracing is currently unchecked. Truth be told I'm not exactly sure why the trace started, except for that we had to reboot the server after a Hotfix install. I do not want it to continue though.

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...

If your former partner was nice enough to give you the free support debugger tool, that may help you as well in your endeavor. Best of luck to you.

It seems to be my theme in life to make things more diffcult than need be. Thank you for your help, I do understand what you are saying, and once I get a chance I will try it out :)

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...

It is a favorite that has been saved. Thank you for your assistance in this matter.

I am in need of finding the person responsible for creating a smartlist for my company. Where should I start looking or is this even possible?