is it possible to automate sql search?

myst.blackmyst.black Posts: 2
edited October 22, 2014 10:51AM in SQL Search
hello, is it possible to automate or use sqlcmd with sql search? I need to search 500 databases for instances of *= or =* (old join types) before I can upgrade the db's these need to be fixed and I was hoping to have a way to automate or use sqlcmd to run the search thru each db and output the dbname and function/view/stored procedure that has the old join type.

thanks!!!
· Share on Twitter

Comments

  • Rob CRob C Posts: 419 Gold 2
    Hi,

    SQL Search is a plug-in for SQL Server Management Studio. There is currently no facility to automate searches but if you would like to suggest new features then you are welcome to at our UserVoice product page.

    Thanks.
    Software Engineer
    Redgate Software
    · Share on Twitter
Sign In or Register to comment.