Francisco Tapia
fhtapia at gmail.com
Tue May 25 10:26:29 CDT 2010
I wrote about that not too long ago... check it out... http://sqlthis.blogspot.com/2009/07/uto-unidentified-table-object.html <http://sqlthis.blogspot.com/2009/07/uto-unidentified-table-object.html> -Francisco http://sqlthis.blogspot.com | Tsql and More... On Tue, May 25, 2010 at 8:11 AM, Jean-Paul natola <jnatola at hotmail.com>wrote: > > > > hI all, > > I'm pretty much suck at sql but I being the ONLY IT person in my > organization , i have to deal with it from time to time. > > I need to find and entry JV0505-10 in the accounting database, but I dont > even know what table to look in, can i search the all the tables from a > single query? if so what would be the syntax? > > The alternative woudl be to export all the tables to excel and search them > > > > the db is ~300 mb and consists of about 180 tables > > thx > > > _________________________________________________________________ > Hotmail has tools for the New Busy. Search, chat and e-mail from your > inbox. > > http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_1 > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >