Problem solved. The incoming parameters need to be stated in the executesql :

CREATE PROCEDURE newPrimaryMainContact

@FName varchar(255),

@LName varchar(255),

@Email varchar(255)

AS

DECLARE @PeopleID int

DECLARE @SQLString NVARCHAR(1000)

DECLARE @params nvarchar(500)

SET @params =...

@PeopleID has already been declared.

So the update to this is that I didnt have the 'sp_executesql in the EXECUTE statement - having added that, now its choking on the @FName...

It is a stored procedure. CF has a tag that passes variables to the sp in sqlserver.

I just dont get it, as it runs fine in query analyzer but bails...

Yes - today coldfusion is spitting this back at me (yesterday it was different although that could have been typos for all I know):

[Macromedia][SQLServer JDBC Driver][SQLServer]The name 'SELECT @PeopleID =...

Done TY

I have a similar problem Im trying to solve.

I need to create a stored procedure which holds 3 different insert statements - one of the inserts occurs on a table...