Use following

DELETE ord

FROM Orders ord

INNER JOIN Customers c(nolock)

ON ord.CustomerID = c.CustomerID

WHERE c.FirstName = 'vikash'

regards,

blog.learnonlinewithme.com

I am also getting the same error:

Exception in thread "main" java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.

        at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source

)

        at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)

        at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)

        at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)

       ...