Although using Stored Procedure in Ms sql is beneficial in many ways, it also has disadvantages in some issues.

Below are some of the negative aspects of using a stored procedure.

Error Finding

Finding errors in Stored Procedure is difficult. They are not recommended to be written too complex or extensive.

Need for Database Administrator

If you work in a corporate company. You may not be able to fully interfere with the application's database. Therefore, you may need the permission of a database administrator. The more stored procedures you use, the more this need will be.

Platform Commitment

Today, many applications run on more than one platform. It should be noted that a written stored procedure will only work on that platform.