Jean-Paul natola
jnatola at hotmail.com
Tue May 25 11:43:58 CDT 2010
yes, and i cought the typo 'SearcAllTablesAllColumns'. I'm not entirely sure how it works in sql but , maybe im saving it incorrectly? or in the wrong location? > Date: Tue, 25 May 2010 09:36:14 -0700 > From: dbdoug at gmail.com > To: dba-sqlserver at databaseadvisors.com > Subject: Re: [dba-SQLServer] search entire db > > I'm not trying to be rude here, but is the name of the sproc that you saved > exactly the same as the name you are trying to execute? > > Doug Steele > > On Tue, May 25, 2010 at 9:23 AM, Jean-Paul natola <jnatola at hotmail.com>wrote: > > > > > 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'. > > > > > > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > _________________________________________________________________ The New Busy is not the old 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_3