Denied EXECUTE permission on object ' sp_sdidebug ' (Database ' master ', owner ' dbo '), I believe many friends have encountered this problem. In particular, when transferring a database, the stored procedure cannot be executed because the permissions of the database owner have changed. This error occurs, usually because it is written like this when the stored procedure is created, Create/alter PROCEDURE [dbo]. [StoredProcedureName], the owner of the stored procedure created by this is dbo, the shorthand for Databaseowner, which performs the stored procedure normally when integrated security=sspi/true as the connection string locally. But when the database is moved to the virtual host, the service provider will not give the SA user password to the customer, but give them a common user name, usually very low permissions, can only execute a specific database stored procedures. Stored procedures cannot be executed when the owner of these stored procedures is dbo rather than the user name provided to the customer by the service provider. This time you must modify the stored procedure to the following style: Create/alter PROCEDURE [StoredProcedureName]
If the stored procedure is a special name, add square brackets, such as user, which is not normally required. This time the stored procedure is executed in the program, and the owner of the stored procedure is the user specified in the connection string instead of dbo, so that it can be executed correctly.