none
sys.sp_databases SP gives me an error on execution. RRS feed

  • Question

  • This is the error I get when I attempt to run this SP:

    Msg 208, Level 16, State 6, Procedure sp_databases, Line 2 [Batch Start Line 7]
    Invalid object name 'sys.sp_databases'.
    
    Completion time: 2019-12-28T13:43:47.3225012-07:00

    Why is it so? I need to get a list of all my databases in SQL Server. It is a bummer! What can be done?

    Thanks, - MyCatAlex


    • Edited by MyCatAlex Saturday, December 28, 2019 8:55 PM
    Saturday, December 28, 2019 8:54 PM

Answers

All replies