The DTC authentication thing is new from windows 2003/XP SP2. So no authentication is required if you have to support windows 2000,NT4...

see http://support.microsoft.com/kb/839279

I can't figure out an easy way. With enterprise library of .NET you can relaunch technical exceptions with user-friendly error messages.

Darn copy paste errors.

Try

Select EmplNO, Max(CTdate) As MaxDate, QuizName

From    tblPreviousWinTrainingLog b  

WHERE (@fromdate is null or CTDate > @fromdate )

AND  ( @todate is null or CTDate <@todate)

AND  (@quiz is null or b.QuizName...

First thing to check if there is anything mentioned in the event-log of windows regarding sql server. This can give a better indication of what the error is (perhaps database ......

Plans are dependant on hardware,software version,statistics,...

Can you isolate the bad performing query (with sql profiler, ... ) and compare the execution plan?

rewrite the first part in . The begin is left out and

fixed the condition @quiz is null in the having clause

Set @quiz = NullIf(@quiz, '')

Set @Unit = NullIf(@Unit, '')

...

Hello,

Can you test if the server is running? (ping...)

What kind of technology you use to connect to sql server (ado,ado.net,oledb,odbc,...) ?

the first query looks like

find the last date that the quizzer (empno) took

insert into #tempPreviousWinTrainingLog (EmplNO,QuizName, CTDate)

select a.EmplNO,a.quizname,MAX(CTDate) as last_date

from tblPreviousWinTrainingLog a

where a.QuizName ='Back Injury Competancy'

group by ...

Can you view the mdb file with Access to list its contents? I hope you have a backup.

Hello,

You could build a tiny table with the translations to join with. Since the values are hardcoded in INFORMATION_SCHEMA.TABLE_PRIVILEGES it isn't likely that the translationtable is already there.

If you lookup...

First thing to check is that dbareport actually has access to the database. Is the server online?

Hello,

You could relocate

AND BE.EmpTypCd = 2

AND StatusDesc.Typ = 1099

AND MoveTypeDesc.Typ = 1102

(BE.EmpFirstNm Like 's%' OR BE.EmpFamiliarNm LIKE 's%')

AND (BE.EmpPrevLastNm LIKE 's%' or BE.EmpLastNm Like 's%' )

AND CF.CustFileStatusDt >= CONVERT(DATETIME, GETDATE()...

Also using mm/dd/yyyy as dateformat is risky since it could be dd/mm/yyyy. Safest way is to use yyyymmdd

Permissions needed (from the books online):

TRUNCATE TABLE permissions default to the table owner, members of the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles, and are...

What servicepack does the Access97 have, SP2?