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