Since there are only 4 possible diagnostic codes

You could create a view using left joins

select  groupedvid.v_id,

from

(SELECT DISTINCT v_id

FROM dbo.mydiagnose mydiagnose

) AS groupedvid

INNER JOIN

(select  l_id,c_id,v_id,createdate,moddate

FROM dbo.mydiagnose mydiagnose

) AS visitinfo

on...

odd issue

What version of query analyzer are you using? (see Help->About)

sql server 2000 sp1 mentions a fix

Query Analyzer Hangs After You Drag && Drop Files Into the Query Editor and...

60% of the improvement can normally found in the application itself,how it handles its data and general design of your database (3NF?)

If possible, check what has changed in the application....

Is there any parallellism in the query plans?

If the cpu is sleeping it could be an I/O issue.

just a sidequestion: why don't you name the object owner?

something from the books online (pivot table)

SELECT togroupby,

    SUM(CASE Group WHEN 1 THEN Amount ELSE 0 END) AS A,

    SUM(CASE Group WHEN 2 THEN Amount ELSE 0 END) AS...

The resore keeps blowing up -> any reported error?

Is the server OS windows 2003 or client OS windows XP SP2?

sure sp_blockinglocks is written alright? (can't find it in the books online)

probably

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q237398&

The "Cannot start transaction while in firehose mode" error occurs when an OLE-DB provider attempts to perform a join transaction with results pending and while not in an...

With enterprise manager you can create scheduled jobs for sql agent.

(management->Sql Agent->Jobs->Create)

Sql Agent then runs it at the specified time.

Perhaps this:

http://www.dbforums.com/archive/index.php/t-958605.html

Have you tried uninstalling and than reinstalling the client components tools of sql server?

You'll need a third party program.

Ortherwise you could try to script out all views, stored procedures and run a text-difference analyzer on it.

See DENY in the books online to prevent insert rights for a specific user.

not sure but this mentions ex_raise2

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

solved in SP4

Does any ends of the distributed query involves an windows 2003 OS or XP SP2 ?