Just execute on master database or a specific database.
SP_MSFOREACHDB' USE ? SELECT ' '?'' AS DATABASE, O.NAME FROM sysobjects O, syscomments s WHERE O.ID=S.ID AND S.[text] LIKE ' '%IX=%''' --OR Use ... GO SELECT O.NAME FROM sysobjects O, syscomments s WHERE O.ID=S.ID AND S.[text] AND TEXT LIKE '%argument%'
The Red Gate Database Delivery team is looking for people willing to participate in UX sessions for an exciting, brand new product, with $50 Amazon vouchers for participants.
2014-04-17
2,901 reads
In his latest blog posts Brent shares his favourite research papers, explaining why he found them interesting and why you might too. STarting off with the Microsoft Research paper Plan Stitch: Harnessing the Best of Many Plans by Bailu Ding, Sudipto Das, Wentao Wu, Surajit Chaudhuri, and Vivek Narasayya (2018)
2019-09-13
