Hi question1 : I am using global temp tables in sql server 2008 but once my connection is closed this temp is dropped is there any way to diable auto drop Question2 : If two connections are accesstion same global temp table and another connection is trying to delete that global temp table,does sql server handles this synchronization properly? from nayeem khan