Home Forums SQL Server 2014 Development - SQL Server 2014 Attempting to change databases using cursor loop, but database won't change RE: Attempting to change databases using cursor loop, but database won't change

  • September 20, 2016 at 2:43 pm

    #1902031

    Luis Cazares (9/20/2016)

    Eric M Russell (9/20/2016)

    Luis Cazares (9/20/2016)

    Here's an alternative that doesn't rely on undocumented procedures.

    ...

    Yeah, but Microsoft doesn't officially support your method either. :satisfied:

    Doesn't support or doesn't have documentation on this usage? It's not the same thing. The method is completely documented, just not as a concatenation solution.

    Yes, I'm talking about documentation. The procedure sp_MsForEachDatabase is well documented by the SQL Server user community. It's OK for one-off maintenance tasks like this one appears to be.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho