What are the challenges you face when working across database platforms? Take the survey

Is there a way to query every database on a given sql server without having to write a cursor?

Could be something like "Select * from dbo.artifact"

Best Answer

  • Options
    Dan_JDan_J Posts: 454 Silver 2
    Answer ✓

    Thanks for reaching out to us regarding this!

    My apology, but would you mind elaborating a little on this just so that I can fully understand exactly what you're looking to achieve here?

    Within the SQL Search UI you can already search across all databases within a given instance:

    Kind regards

    Dan Jary | Redgate Software
    Have you visited our Help Center?
Sign In or Register to comment.