I also changed your code from ALTER PROCEDURE to CREATE PROCEDURE (and added the IF...DROP 😉 ):

IF OBJECT_ID ('sp_capture_login_auths') IS NOT NULL

DROP PROCEDURE sp_capture_login_auths

GO

CREATE PROCEDURE [dbo].[sp_capture_login_auths] @user...

First of all thanks for this nice peace of code 🙂

I tried running it on my SQL 2012 and got this error:

The module 'sp_capture_login_auths' depends on the missing...