Home Forums SQL Server 2008 SQL Server 2008 - General How to Loop through all DBs in an Instance? RE: How to Loop through all DBs in an Instance?

  • January 24, 2013 at 12:17 am

    #1580373

    Kingston Dhasian (1/23/2013)

    tom.moore.777 89426 (1/23/2013)

    Can anyone provide a method to loop through a DB's in an instance WITHOUT using the proc sp_MSforeachdb

    Any particular reason for avoiding the use of sp_MSforeachdb?

    msForeachdb has a few bugs and limits.

    iirc there was a character limitation. There is also inconsistent behavior such as it skipping databases.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events