If you use triggers be sure to add the line

SET NOCOUNT ON after the "AS" to reduce roundtrips.

CREATE TRIGGER LastEditDate ON ManifestHeader FOR INSERT,UPDATE

AS

SET NOCOUNT ON

...

see

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1057991,00.html

Depends on how high the fragmentation level is. One advantage of dbcc indexdefrag is that you can continue to work. A disadvantage is that all it operations are logged, resulting...

Hello,

Have a look at:

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

*lost typing

Have a look at

http://www.sql-server-performance.com/sql_server_performance_audit.asp

for some info about performance counters etc.

Resetting the service also clears any outstanding transactions/locks. Try to figure out which queries are taking longer (sql profiler),...

perhaps this

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

Is the server up to date with patches?

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