Its not that mass searching but easy to script a find that having to open each table and look at it to find a value. There are about 120 tables.
2012/7/30 Willoughby <[email protected]> > If you need to do mass searching on a big database, I'd keep it on > SQLServer and use the Full Text Search service. > http://msdn.microsoft.com/en-us/library/cc721269%28SQL.100%29.aspx > > On Monday, July 30, 2012 7:01:33 AM UTC-4, Ramos wrote: >> >> Hello i have a problem >> i have a big sqlserver database called MXPROD with dozens of tables. >> I need to find tables that have 01533 in one of the field of the table. >> this field in one of the tables was named eqnum but i dont know if other >> tables use the same name for the field. >> >> How can i script this using python? >> >> Thank you >> >> António >> > -- > > > > --
