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

Kishore_1983Kishore_1983 Posts: 1 New member
in SQL Search
Could be something like "Select * from dbo.artifact"
Tagged:
· Share on Twitter

Best Answer

  • Dan_JDan_J Posts: 459 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?
    · Share on Twitter
Sign In or Register to comment.