thanks for the reply David! I got your point made, yes its definetly important to check the queries that are running against the SPID before killing it and check to...

I recently migrated databases from sql 2000 to sql 2005, the logins too got migrated, however I had to use these SPs to fix or map the logins that were...

Thanks alot!

thank you! can you please provide me with some examples , as to how the results would look, if any error in the database was spotted...after running these DBCC commands?...

Running it frequently..does it mean that we need to run these commands say very week on all the databases? doesnt it affect the overhead performance? if we need to run..then...

thanks for the quick reply