Jean-Paul natola
jnatola at hotmail.com
Fri Dec 10 14:14:00 CST 2010
found it , was missing the > symbol thanks AGAIN!!!!! Jean-Paul Natola > From: jnatola at hotmail.com > To: dba-sqlserver at databaseadvisors.com > Date: Fri, 10 Dec 2010 15:12:15 -0500 > Subject: Re: [dba-SQLServer] SPROC not working > > > That was it / kind of, > > now i'm getting this > > Msg 102, Level 15, State 1, Procedure SearchAllTablesAllColumns, Line 40 > Incorrect syntax near '@TableName'. > > this is line 40 > > QUOTENAME(C.Table_name) + '.' + QUOTENAME(COLUMN_NAME) @TableName + '.' + @ColumnName ) > > > > Jean-Paul Natola > > > > > > > From: fhtapia at gmail.com > > Date: Fri, 10 Dec 2010 11:39:45 -0800 > > To: dba-sqlserver at databaseadvisors.com > > Subject: Re: [dba-SQLServer] SPROC not working > > > > 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 > > > > > _______________________________________________ > > 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 >