Skip to main content Link Menu Expand (external link) Document Search Copy Copied

sp_Develop Usage Instructions

After installing the sp_Develop stored procedure, open SQL Server Management Studio and run in the database you wish to check for database development best practices.

EXECUTE dbo.sp_Develop;

That’s the bare minimum you need to run the best practice checks!

If you are new to sp_Develop, it is recommended you start with the SQL statement below to limit the number of findings.

EXECUTE dbo.sp_Develop @PriorityOrHigher = 'High';

Visit Parameter Explanations for more options

What the results mean View on GitHub