Pervasive (BTR) Betrieve with DDFs.

Why reclaim it .... if it will be used as needed or is this unusable?

We've been able to tie this to outlandish queries that run with thousands of items in an WHERE IN () list.

Sound reasonable.

We only allowed it to apply a hot fix. 

Thanks

 I've got it on, however:

Does the 98% Dimension table read concern me.  Is it using 90% Processor Time?  This is a simple...

We ran into some performance issues.  We're applying a HotFix now and watching poor performance queries to see in index's would help.  I thought you-all might know of some SQLServer...

How do I nail the issue down so I can go speak with the right person?

You might consider DTS for copying objects if  you have connectivity.

I had to do a CINT on all integers coming it ... an ODBC data conversion issue.

Thanks for your replies.

Running a DBCC my databases are hosed.  

Server: Msg 7995, Level 16, State 1, Line 1 Database 'My DB' consistency errors in sysobjects, sysindexes, syscolumns, or systypes prevent further CHECKDB...

I've gotten the debugger to work fine for dts but we only have it on in our development environment.  When a job fails a window appears with the erroring line. ...

More specifics about my current error:

Statement:  If  DTSSource("Field2") = 0 Or IsNull(DTSSource("Field2"))  Then

Error:  Expected 'End' ... this is a run time error. This statement parses fine

I've come to find that this issues is occuring because DTSSource("Field2") is 0.  I want to make an

IF ISNULL(DTSSource("Field2")) and DTSSource("Field2") = 0 Then

but I keep getting and error. ...

Same source, differnt table.

Enterprise Manager.  SQL Server 2000