CREATE PROCEDURE CustomerAddress_UPDATE @CustomerId BIGINT, @HouseNo NVARCHAR(100), @StreetAddress1 NVARCHAR(100), @StreetAddress2 NVARCHAR(100), @Town NVARCHAR(100), @County NVARCHAR(100), @PostCode NVARCHAR(100) AS UPDATE [dbo].[Customer] SET propertyName=@HouseNo, streetAddress=@StreetAddress1, streetAddress2=@StreetAddress2, town=@Town, county=@County, postcode=@PostCode WHERE customerID=@CustomerId
Msg 262, Level 14, State 1, Procedure CustomerAddress_UPDATE, Line 12 CREATE PROCEDURE permission denied in database 'master'.
use [Your database name]
USE
USE YourDatabaseName; GO CREATE PROCEDURE CustomerAddress_UPDATE --the body of SP
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)