[dba-SQLServer] search entire db

I know this is trivial to the rest of you, but HOW do i add/register/create it

I tried to create new sproc , copied the code into it , saved it and when I try to execut it it returns

 

Msg 2812, Level 16, State 62, Line 1

Could not find stored procedure 'SearcAllTablesAllColumns'.






 
> From: fhtapia at gmail.com
> Date: Tue, 25 May 2010 08:26:29 -0700
> To: dba-sqlserver at databaseadvisors.com
> Subject: Re: [dba-SQLServer] search entire db
> 
> 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
> >
> >
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
 		 	   		  
_________________________________________________________________
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