if you are using SQL Server 2005 then then Report namely schema changes would help you to view the schema changes in your DB.

Hi,

you can do 1 thing when creating a temp table append the random number with ur temporary table which will help u in blocking.

also specify the locking hint(use BOL...

Hi buddy,

Try to use this format of date while checking date....either '01-April-2007' Or '04012007'