Thanks a lot ! The Web service Timeout concept worked !

If we give the WebService Timeout = -1 , then it is assumed to be infinite timeout.

-Sandeep

Gr8 !!!

Thank you for ur help.

Hi,

You can kill the process using 'Kill' in SQL Analyser.

Example you have spid =5.

Kill 5

will kill the process with SpID 5.

Till you disconnect all the Database...

Hi,

thanks for ur reply.

But could you pls tell me wat is SQL-DMO ? and how should I go ahead with it ?

Ya thats fine..

But could you pls let me know how to generate script,if u know the same. ?

Thnaks in advance//..

No u didn't get my question.

By dynamic SQL we can create a table.But I want that,...

Table is already created, I want to extract the SQL 'CREATE' script for the table.As...