Francisco Tapia
fhtapia at gmail.com
Fri Dec 10 13:39:45 CST 2010
Be sure you execute the create Sproc procedure on the target database Sent from my mobile On Dec 10, 2010, at 11:08 AM, Jean-Paul natola <jnatola at hotmail.com> wrote: > > Hi all, > > A many many months back i added the SearchAllTablesAllColumns sproc to my sql server and it worked well, > > I have created a new server and tried to create that same sproc, but now when i try run it i get > > Msg 2812, Level 16, State 62, Line 1 > Could not find stored procedure 'SearchAllTablesAllColumns'. > > > > one other thing is that when I save it I DONT see the sproc in sql, i see it in the "my projects" folder. > > I really need to get this working as i'm running into some issues with our GP migration, and the ability to search all tables/columns is crucial. > > > TIA > > JP > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com >