Updating a database stored procedure

Posted by / 24-Nov-2020 01:28

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.

updating a database stored procedure-63updating a database stored procedure-33updating a database stored procedure-23

For avoiding the errors if no value is passed for the parameters, you may use the default values as creating the stored procedure.