I am a new DBA working with several more experienced DBA's. When I am scratching my head one of them says "oh just run SP_xx_xx", and sure enough that begins the path to solution.
Of course they all just know them, I have decided to start a list. I have not been writting them all down, so all I have in my list is these three.
- sp_change_users_login 'report'
I Googled and came up with some very old lists
- Useful system stored procedures in SQL Server(SO)
- Two Dozen of My Favorite System Stored Procedures, By Kiely, Don
What are the best or most helpful Stored Procedures for a New DBA to have in their tool kit, for SQL 2012/2014?