Updating a database stored procedure
Ownership chaining The databases involved have the option set or the 'cross database ownership chaining' option turned on at the server level.In the case of dbo-owned objects, the databases must also the same owner (i.e.
For that, you may write a stored procedure that returns the data along with updating option.
This also implies the databases also have the same owner.
I suggest you change the database owner for databases where non-sysadmin role members can create dbo-owned objects to mitigate security risk.
Visit Stack Exchange Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Sign up to join this community create proc UPDATE_PRODUCT @ID_CAT INT, @ID_PRODUCT VARCHAR(30), @LABEL NVARCHAR(30), @QTE INT, @PRICE VARCHAR(50), @IMG IMAGE AS UPDATE [Product_DB].[dbo].[PRODUCTS] SET [ID_CAT] = @ID_CAT ,[LABEL_PRODUCT] = @LABEL ,[QTE_IN_STOCK] = @QTE ,[PRICE] = @PRICE ,[IMAGE_PRODUCT] = @IMG WHERE ID_PRODUCT = @ID_PRODUCT When I run this code the first time, it says "completed successfully" However, I can't find it in Stored Procedure folder.
I tried to do multiple refreshes and restarts but still the same.
For avoiding the errors if no value is passed for the parameters, you may use the default values as creating the stored procedure.