Thanks SJCSystems.

I want it to delete from base database (which is alias b) based on A.Update_Type = 1. But your suggestion reminds me of one thing. May be i need...

Use DBCC CheckDB

DBCC CHECKDB (<dbname>, NOINDEX, <repair option>) WITH ALL_ERRORMSGS

Quote from BOL:

_____________________________________________

Value Description

REPAIR_ALLOW_DATA_LOSS Performs all repairs done by REPAIR_REBUILD and includes allocation and deallocation of rows and pages for...

Manual is probably the best.

Use Exec stmt

Exec(@some_string )

Creating a temp monitor table and poll this table at regular intervals (say every 30 sec) from my front end using a timer control.

Can't you issue a Delete stmt to DB2 thru the same way you issue a Select stmt?

May be you need to have "With" verb before (NOLOCK). I did not try and i am not sure.

Best starting point:

Data Warehouse Tool kit by Ralph Kimball

Foreward by Inmon.

You might want to post this in appropriate forum.

I have experienced something similar before i installed SQLServer service pack. Try installing latest service pack.

What is active/active and active/passive

I tried something similar to this and it works. May be you are missing something minor. What is the error msg you get?

1)Definitely create Primary Key.

2). Have lot of test data and create a workload.

3). Use Index Tuning wiz.

4). Use Profiler and get the timing.

5). Look at the...

This would probably help with what you need:

select left(o.name, 30) 'Table Name', left(i.name, 30) 'Index Name', i.indid, i.status from sysobjects o inner join sysindexes i

on o.id = i.id and...

continue this thread