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

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!!!

Comments

  • Options
    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
Sign In or Register to comment.