I was transferring a database from one place to another and had to use scripts. Here is the Stored Proc that failed:
CREATE PROCEDURE [dbo].[Smith_DeleteShoppingCartBundle]
(
@bundleID int,
@masterBundleID int
)
AS
BEGIN
DELETE FROM Smith_ShoppingCart
WHERE [BundleID] = @bundleID AND [MasterBundleID] = @masterBundleID
END
GO
====================================================================
Msg 207, Level 16, State 1, Procedure Smith_DeleteShoppingCartBundle, Line 10
Invalid column name 'MasterBundleID'.