Click here to Skip to main content
15,908,166 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am trying to create a query that requires no input and every time you run,it generates the same result. But it won't execute.
Generated Error:CREATE PROCEDURE permission denied in database 'master'.

I know this is a lie because i just created 2 query's right before this one

SQL
Create Procedure Get_Asset_Condition

@Condition nvarchar (50)
As

SET @Condition = 'Good'
SELECT ID FROM AssetTracker_AssetCondition WHERE Name = @Condition



Thanks for your help
Posted

1 solution

 
Share this answer
 
Comments
CPallini 6-Nov-13 9:49am    
5.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900