我正在尝试创建一个storedproc但我得到一些错误，任何人都建议我 [英] I am trying to create a storedproc but i am gettin some error any one pls suggest me

问题描述

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

我收到此错误：

I am getting this error:

Msg 262, Level 14, State 1, Procedure CustomerAddress_UPDATE, Line 12
CREATE PROCEDURE permission denied in database 'master'.

推荐答案

好吧，错误消息很明确：您没有权限更改此数据库的ddl。与具有适当权限的用户联系。

Google是您的朋友：

http://menononnet.wordpress.com/2011/03/07/create-database-permission-denied- in-database-master-microsoft-sql-server-error-262 / [ ^ ]

http://blogs.msdn.com /b/dparys/archive/2009/09/17/create-database-permission-denied-in-database-master-my-fix.aspx [ ^ ]

Well, the error message is quite clear: you don't have the permission to alter the ddl of this database. Connect with a user having proper permissions.
Google is your friend:
http://menononnet.wordpress.com/2011/03/07/create-database-permission-denied-in-database-master-microsoft-sql-server-error-262/[^]
http://blogs.msdn.com/b/dparys/archive/2009/09/17/create-database-permission-denied-in-database-master-my-fix.aspx[^]

添加bel ow sql到你的脚本顶部

add below sql to top of the your script

use [Your database name] 

正确选择数据库名称@left sql server，设置数据库名称。

否则发送一些其他细节

select the db name properly @left side of sql server,set your database name.
Else send some other details

这篇关于我正在尝试创建一个storedproc但我得到一些错误，任何人都建议我的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！