Try to RDC into the machine which has the application and ping the DB server, if it dosent work then there might be some problem in the Domain.

If the above...

Thanks Jeff

I will try using the deletion Crawler, since applicaitons are using this tables at the time of...

Its only a subset, if its a whole table that would be so nice.:(

Cheers

Thanks Mwolf

I am taking off all the records on a temp table, so i think...

Just once a day early morning to move data from one table to other table,

Cheers

Hi

I dont have a execution plan , but the table index structure is as below

IX_OQa_Binonclustered, stats no recompute located on PRIMARYBi

IX_OQa_Blo_Binonclustered, stats no recompute located...

Thanks Guys

There are no Foregin keys for this table, and i am using Primary key which is used on both the...

Thanks Young

This is the exact Query i use to delete the table contents expect the table...

Thanks for the response

This is the code, i have inserted the records into a temp table from tableA and then insert this record into TableB, once inserted into Table B,...

Hi Jon

There were so many new futures that you can use on 2008, i just migrated into 2005 from 2000, i personally would...

Did you inclue any jobs recently or did any changes, this might affect as well, i faced the same problem and when i looked into it, it was a SP...

Hi Ambuj

You can use the below 2 scripts to check wether ur SQL server is running or not

--...

yes jeff, its the Ph column

Thanks Jeff

I am Using nearly 48 tables(4 years worth of tables) and yes its SQL 2005 (64 Bit),...

Thanks a lot guys, this is great,

Cheers