ThanQ for the solution.

But i want to drop the identity property of that coloumn.

How can i do it in TSQL. please let me know.

TanQ very much for ur prompting reply.

I m using th first solution u have given me.

Using clustered index.

ThanQ.

Thank you for the given solution.

But is there any direct command like

'create table sample ...on <filegroup>'.... for select...into...statement.