try

USE mytargetdatabase

SELECT TABLE_CATALOG, TABLE_NAME

FROM INFORMATION_SCHEMA.TABLES

WHERE TABLE_NAME = OBJECT_NAME(1852795252)

this site has a lot of info about repairing mdac

It mentions windows xp2 but may work as well for windows 2003 sp1

http://www.macropool.com/en/download/mdac_xp_sp2.html

any size differences between the specific database and the others?

looks you have some database corruption

http://www.mssqlcity.com/FAQ/Trouble/er605.htm

Could you post the stored procedures or the query that takes a long time to run?

Seems it could use some review.

quite late here, there is probably a better query.

IF EXISTS(SELECT *

from MeetingAttendance

WHERE MeetingID=@MeetingID

AND MeetingDate BETWEEN @StartDate AND @EndDate

)

BEGIN

    select employees.EmployeeID

    from MeetingAttendance /*AVAILABLE MEETINGS*/

    WHERE MeetingID=@MeetingID...

You can use the sql profiler to track down cpu-intensive queries.

What is the number of stored procedure recompilations/sec?

If I am reading it correctly

Employees: list of all employees

MeetingAttendance: all employees present at a meeting

Where is the reference of who needs to be present?

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?