my proc has given below

----------------------------------

USE [indbank]

GO

/****** Object: StoredProcedure [dbo].[USP_ComputeAll_NPA] Script Date: 10/27/2014 2:59:34 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROC [dbo].[USP_ComputeAll_NPA]

@UPLOAD_DATE DATE,

@ERRORFLAG BIT OUT,

@ERRORMSG ...

Thanks for reply to all

Thanks for your response sir,

Rajnidas

thanks for response

Thanks for your response its working as your suggest.

.net frame are same in both machine

thanks

it was working in local machine but not in live production server .

thanks

no sir,

running project at same machine but live project machine.

thanks