Thank you for pointing me in the right direction. Found what I needed at

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

Roger

I ended up uninstalling and then reinstalling SQL 2005. Whatever was the issue was resolved by taking this approach. Problem is resolved.

Thank you everyone for your responses.

Roger

Sorry for the confusion... yes, there are regular backups. Just don't know how long this situation has occurred from within the database. So I wouldn't know where to...

This appears to be the more complete message:

Msg 2508, Level 16, State 3, Line 1

The In-row data RSVD page count for object "Freight_Rate", index ID 0, partition ID 60134411927552, alloc...

Thank you for the insight. When I run it, I get the following message:

CHECKDB found 0 allocation errors and 1 consistency errors in table 'Freight_Rate' (object ID 917578307).

How would...

Thanks. I migrated a SQL 2000 DTS package. Do these SSIS packages appear from within the SQL Management Studio itself?

Roger

Thanks. But what if all they had were device cals? They would still need user cals?

Roger

Thanks! That worked very well! Now I'm just trying to add an underscore if there's a hyphen and I keep getting a message about the Len argument ->...

I ran the SQL script found at http://www.sqlservercentral.com/columnists/losmith/automatedtracefilecollection.asp

and get the following message when it completes:

Msg 19055, Level 16, State 1, Procedure sp_trace_setfilter, Line 1

Filters with the same event...

Sure.....

-- Set the Filters

declare @intfilter int

declare @intdbFilter int

declare @bigintfilter bigint

exec sp_trace_setfilter @TraceID, 10, 0, 7, N'SQL Profiler'

set @intfilter = 100

exec sp_trace_setfilter @TraceID, 22, 0, 4, @intfilter

-- check for...

Thank you for the suggestion but that didn't resolve it.

Roger

Thanks! I should have tried that!

Roger

Thanks! I get trying to use the DATEADD function again in the same line.

Roger

That's exactly what it turned out to be.

Thank you.

Roger

I guess I could have them buy the basic SQL Server 2005 Standard Edition and then add CALs to it instead of the going the two processor route?