100% cpu usage

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Jim (jcm_at_nb.net)
Date: 06/18/04 

Date: Fri, 18 Jun 2004 04:45:33 -0700

Access 2002 adp connected to SQL server, running through
terminal services. When I execute any command through ADO
(sample below), the cpu usage immediately jumps to 100%
and stays there. Needless to say all other users (3-4)
are dead in the water until the command is done. It
occurs whether I am executing a stored procedure or
passing a sql string.

Any ideas?

           Dim cmd6 As ADODB.Command
6380 Set cmd6 = New ADODB.Command
6390 cmd6.ActiveConnection = cnnConnection
6400 cmd6.CommandText = "sp_WABillPrintUpdate"
6410 cmd6.CommandType = adCmdStoredProc
6420 cmd6.Parameters.Refresh
6430 cmd6.Parameters(1).value = Me!cboBillingGroup
6440 cmd6.Execute , , adAsyncExecute
6450 Do Until cmd6.state <> adStateExecuting
6460 Loop
6470 Set cmd6 = Nothing

Relevant Pages

  • Execute Process Task not failing, but not executing the batch comm
    ... I can execute the following command from the windows "Run" prompt and it ... Might I have something set weird in SQL Server? ... server being by default configured to run as localsystem account, ...
    (microsoft.public.sqlserver.dts)
  • Re: ADO.NET Timout
    ... That in turn execute SP ... BeginExecute method of the Command object. ... How can I call a stored procedure to do its thing asynchronously. ... see "Explicit Transactions" in SQL Server Books ...
    (microsoft.public.dotnet.framework.adonet)
  • SqlClient Data Adapter Fill Method
    ... I am having a problem with the SqlClient Data Adapter. ... the problem by placing a trace on my sql server and watching which stored ... method of the data adapter does not appear to execute my command object. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SqlClient Data Adapter Fill Method
    ... If you are specifying lengths on ... that Sql Server is seeing look ok? ... >>> method of the data adapter does not appear to execute my command ... >>> errors are raised the fill command just returns 0 rows and I do not see ...
    (microsoft.public.dotnet.framework.adonet)
  • [Full-Disclosure] Advanced usage of system() function.
    ... and call its arguments as a command for shell. ... as we can see we still didnt get what we want (typing exit ... Connection closed by foreign host. ... think what we want to execute. ...
    (Full-Disclosure)