Well....

Good hint. i was thinking on the same line.

Thanks.

But Load mean what.

Should i use XMLDocument Object to load the xml file and pass this object as parameter value?

can you provide some sample code for this?

It does work but i want to apply the condition here.

Thanks Noel,

Thats what something i was looking for.

Appreciate your help.

Regards,

Syed

Thanks Gift,

Your link does provided me some guidence on how to go ahead.

About the SQL server 2008 link :crying: i don't have any plan of going with that.

Thanks,

Syed

Thanks Gift for all the suggestion but that doesn't solve my problem.

I am thinking of using SELECT INTO...but the problem is that it copies the data also.

is there any way...

Is it possible to pass a table name as argument into the stored procedure?

All i need is to create a table dynamically into the SQL server 2005 from my application?

Could...