adding Trusted_Connection=true  means it needs to be windows authenticated.

Second, connecting as sa is a very serious security risc. I hope sa has a password.

found a kb article that might apply: (for standard edition)

http://support.microsoft.com/kb/316749/

Otherwise, are you profiling any performance counters?

found a kb article that might apply: (for standard edition)

http://support.microsoft.com/kb/316749/

Otherwise, are you profiling any performance counters?

select ...

from table1

where not exists (select PERMIT_ID from table1 table_bad where table1.PERMIT_ID=table_bad.PERMIT_ID and table_bad.PERMIT_EVENT_DT is null)

If could be rewritten to replace not exists, by some form of counting those whose...

Thanks for posting the solution.

Is it possible to post a link describing the issue with the cpu?

In such situations it is always helpfull to compare the execution plans of the queries, you can do this via the query analyzer: (Query) show estimated execution plan.

Possible reasons: the...

Looks your tempdb is running full or it can't grow fast enough.

Can you split your command in batches of 100 000? With a counter or something to remember the highest...

Raid 5 isn't particulary recommended if there is a lot of writing activity. Looks splitting it up would be ideal. Can't say more since the largest raid I have are...

not sure if it will work, but you will need an error check too at

OPEN C_TESTE

 FETCH NEXT FROM C_TESTE  INTO @CONT

->error check

Can you give some textual output data?

Some things that might improve:

Union -> Union All

Rewrite CONVERT(varchar(10),ud.[date],110)=CONVERT(varchar(10),i.[itdate],110) to use BETWEEN instead of performing a function on a column

Does it work when you write a parameterquery (as a query object) and use that query for the recordsource?

Is vwIndivPTMFcastbyProject a linked table or do you

use T-SQL?

Can you output debug.print strSQL or msgbox strSQL to verify strSQL?

Have you installed/reinstalled mdac 2.8? A newer version of mdac is already included in windows xp servicepack 2

Found a link on possible related error 126:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=91285&SiteID=1

pity me, I switched deleted (previous data) with inserted (new data)

CREATE TRIGGER TR_TEST_MANDATORY ON dbo.TEST for UPDATE, DELETE

AS

SET NOCOUNT ON

IF EXISTS(SELECT col1 from deleted /*old data*/ WHERE col1 in ('one','five'))

BEGIN

ROLLBACK TRANSACTION

END

Now...

Goodday Homero

Could you try the following:

Making sure all previous installations are removed:

*No antivirus/antispyware program are running and that all sql server services are stopped.

Microsoft has some detailed steps on manually removing sql...