[dba-SQLServer] search entire db

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



More information about the dba-SQLServer mailing list