How can we help you today? How can we help you today?

is it possible to automate 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!!!
myst.black
0

Comments

1 comment

Sort by
  • Rob C
    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.
    Rob C
    0

Add comment

Please sign in to leave a comment.