Thanks for this.. i will try this..

1 More thing:

i have one Sql Table and a temp table..

i want to extract whole data from Sql table to temp table without giving any

field name..

like INSERT INTO ##temp

SELECT * FROM [Table name]

But its not working.

any help?????