Hi,

I am using stored procedures in the vwd 2008 IDE that integrates SQL server. I have declared like a number of variables in my sproc as shown below. The problem I am having is that when I run it in the browser I get 'Sql exception thrown' whereas if i run the sproc directly in the IDE, it works okay. I noticed that it is not accepting further variable declarations if i run in the browser. Is there a limit? anyone familiar with vwd 2008? Thanks.

Code:
@firstname varchar(50),
	@surname varchar(50),
	@dateOfBirth datetime,
	@nationality nchar(20),
	@title nchar(5),
	@idNumber nvarchar(50),
	@dateOfRegistration datetime,
	
	@residentialAddress nvarchar(100),
	@residentialAddresscode nvarchar(10),
	
	@postalAddress nvarchar(100),
	@postalAddresscode nvarchar(10),
	
	@workPhone int,
	@workPhoneCode int,
	@x int,
	@homePhone int,
	@homePhoneCode int,
	
	@faxNumber int,
	@faxNumberCode int,
	
	@cellularPhone int,
	@email nvarchar(30),
	
	/* setting student's finance info 

	@paymentMethod varchar(20),
	@paymentPlan varchar(20),
	*/
	@debitAccountFullName varchar(100),
	@bank nvarchar(50) = null,
	@branch nvarchar(20) = null,
	@branchCode int = 0,
	@debitOrderAccountNumber nvarchar(30) = null,
	@debitAccountDate datetime = null,
	
	/*
	
	@ccAccountNumber int,
	@ccDebitAccountFee float,
	
	@creditCard nvarchar(50),
	
	@newCreditCard nvarchar(50),
	@cvc int,
	@cardExpiryDate datetime,
	@ccBudgetMonths int,
	
	
	
	@ccBudgetAccountID int = 0,
	@newCreditCardID int = 0,
	@cardTypeID int = 0,
	@ccID int = 0,
	@ccFinanceEntityID int = 0,
	*/		
	@residentialID int = 0,
	@postalID int = 0,
	@workPhoneID int = 0,
	@homePhoneID int = 0,
	@cellularPhoneID int = 0,
	@faxNumberID int = 0,
	@paymentPlanID int = 0,
	@paymentMethodID int = 0,
	@selectedPaymentPlanID int = 0,
	@selectedPaymentMethodID int = 0, 
	@newBankBranchID int = 0,
	@newBankID int = 0,
	@newDebitOrderAccountID int = 0,
	@debitOrderAccountID int = 0,
	
	@errorMessage nvarchar(100),
	@intErrorCode int OUTPUT,
	@newStudentID int OUTPUT