No.

>Could it be that this SP is in different schema?
>
>>Yes & No:
>>
>>When I run this in SQL:
>>
>>

>>USE WorkIT
>>declare @p1 bigint
>>set @p1=NULL
>>exec wit_AddAddress @AddressKey=@p1 output,@AddressTypeKey=456,@Street1=N'AAAAAAAAAAAAAA',@Street2=N'AAAAAAAAAAAAAAA',@City=N'AAAAAAAAAAAA',@State=N'AA',@PostalCode=N'AAAAA'
>>select @p1
>>
>>

>>
>>I get the same error. Yet the sproc IS in the database.
>>
>>
>>
>>
>>
>>>Did you verify that this SP in in correct database? Did you try running it directly in SSMS?
>>>
>>>>I have a SQL stored proc called wit_AddAddress:
>>>>
>>>>

>>>>CREATE PROCEDURE wit_AddAddress
>>>>	@AddressTypeKey	INT,
>>>>	@Street1	VARCHAR(100),
>>>>	@Street2	VARCHAR(100),
>>>>	@City		VARCHAR(40),
>>>>	@State		CHAR(2),
>>>>	@PostalCode	CHAR(10),
>>>>	@AddressKey	INT = 0 OUTPUT
>>>>AS
>>>>
>>>>BEGIN
>>>>
>>>>	INSERT INTO wit_AddAddress
>>>>		(AddressTypeKey, Street1, Street2, City, State, PostalCode)
>>>>		VALUES
>>>>		(@AddressTypeKey, @Street1, @Street2, @City, @State, @PostalCode)
>>>>		
>>>>	SET @AddressKey = SCOPE_IDENTITY()	
>>>>
>>>>END
>>>>

>>>>
>>>>I have verified that this proc is there in SQL. When I run the following C# code, I get the error "Invalid object name 'wit_AddAddress'":
>>>>
>>>>

>>>>public override bool SaveChanges()
>>>>{
>>>>    bool RetVal = Validate();
>>>>
>>>>    if (RetVal)
>>>>    {
>>>>        string ProcName = string.Empty;
>>>>
>>>>        SqlParameter pAddressKey = new SqlParameter("@AddressKey", 0);
>>>>
>>>>        if (this.RecordId == 0)
>>>>        {
>>>>            pAddressKey.Direction = ParameterDirection.Output;
>>>>            ProcName = "wit_AddAddress";
>>>>        }
>>>>        else
>>>>        {
>>>>
>>>>            pAddressKey.Value = this.RecordId;
>>>>            ProcName = "wit_UpdateAddress";
>>>>        }
>>>>       
>>>>        SqlParameter pAddressTypeKey = new SqlParameter("@AddressTypeKey",_AddressTypeKey);
>>>>        SqlParameter pStreet1 = new SqlParameter("@Street1", _Street1);
>>>>        SqlParameter pStreet2 = new SqlParameter("@Street2", _Street2);
>>>>        SqlParameter pCity = new SqlParameter("@City", _City);
>>>>        SqlParameter pState = new SqlParameter("@State", _State);
>>>>        SqlParameter pPostalCode = new SqlParameter("@PostalCode", _PostalCode);
>>>>
>>>>        ArrayList colParams = new ArrayList();
>>>>        colParams.Add(pAddressKey);
>>>>        colParams.Add(pAddressTypeKey);
>>>>        colParams.Add(pStreet1);
>>>>        colParams.Add(pStreet2);
>>>>        colParams.Add(pCity);
>>>>        colParams.Add(pState);
>>>>        colParams.Add(pPostalCode);
>>>>
>>>>        AppDataAccess.ExecuteNonQuery(ProcName, colParams);
>>>>
>>>>        if (AppDataAccess.DataException == null)
>>>>        {
>>>>
>>>>            if (pAddressKey.Direction == ParameterDirection.Output)
>>>>            {
>>>>                this.RecordId = Convert.ToInt32(pAddressKey.Value);
>>>>            }
>>>>        }
>>>>        else
>>>>        {
>>>>            throw AppDataAccess.DataException;
>>>>        }
>>>>    }
>>>>
>>>>    return RetVal;
>>>>}
>>>>

>>>>
>>>>When called for edits, the reference to "wit_UpdateAddress" works. Like I said, the proc is there. Anyone know why this would be happening????