MS SQL Server 2005 issues with my trigger statement...

Can someone help please...

Im getting this error..

Msg 102, Level 15, State 1, Procedure test_Product_Change_To_Product, Line 76
Incorrect syntax near '@GL_ID'.

---

CREATE TRIGGER test_Product_Change_To_Product
ON temp_Product
--DECLARE @id int

AFTER INSERT, UPDATE, DELETE


As
   
    DECLARE @GL_ID nvarchar(max)
      DECLARE @WIT_ID nvarchar(max)      
      DECLARE @SPELL_CHECK nchar(10)      
      DECLARE @HTML_FORMAT nchar(10)      
      DECLARE @PARENT_COMP nvarchar(max)
      DECLARE @WEBSITE_TYPE nvarchar(max)
      DECLARE @SHOP_CART nvarchar(max)      
      DECLARE @EMAIL nvarchar(max)      
      DECLARE @DOMAIN nvarchar(max)      
      DECLARE @HOME_PAGE nvarchar(max)             
      DECLARE @CONTACT_PAGE nvarchar(max)
      DECLARE @PRODUCT_PAGE nvarchar(max)
      DECLARE @COMPARE_CHART nvarchar(max)
      DECLARE @PRODUCT_1 nvarchar(max)             
      DECLARE @PRODUCT_2 nvarchar(max)      
      DECLARE @PRODUCT_3 nvarchar(max)            
      DECLARE @PRODUCT_TRIAL nvarchar(max)
      DECLARE @OVERVIEW nvarchar(max)
      DECLARE @SUPPORT_CENTER nvarchar(max)
      DECLARE @USER_FORUM nvarchar(max)      
      DECLARE @UNINSTALL_UTILITY nvarchar(max)
      DECLARE @LICENSE_CENTER nvarchar(max)       
      DECLARE @ABOUT nvarchar(max)       
      DECLARE @BLOG nvarchar(max)       
      DECLARE @FAQ nvarchar(max)                  
      DECLARE @CAREERS  nvarchar(max)       
      DECLARE @PRODUCT_ITEM_1 nvarchar(max)
      DECLARE @PRODUCT_ITEM_2 nvarchar(max)      
      DECLARE @PRODUCT_ITEM_3 nvarchar(max)       
      DECLARE @CATEGORY_ID nvarchar(max)


SELECT       @GL_ID = GL_ID,      
       @WIT_ID  =  WIT_ID ,       
       @SPELL_CHECK  = SPELL_CHECK ,
       @HTML_FORMAT        =  HTML_FORMAT  ,       
       @PARENT_COMP  =  PARENT_COMP  ,
       @WEBSITE_TYPE = WEBSITE_TYPE  ,
       @SHOP_CART         =  SHOP_CART ,      
       @EMAIL   =  EMAIL  ,
       @DOMAIN   =  DOMAIN  ,
       @HOME_PAGE  =  HOME_PAGE  ,      
       @CONTACT_PAGE  =  CONTACT_PAGE ,
       @PRODUCT_PAGE  =  PRODUCT_PAGE  ,
       @COMPARE_CHART  =  COMPARE_CHART ,
       @PRODUCT_1  = PRODUCT_1 ,      
       @PRODUCT_2  =  PRODUCT_2 ,      
       @PRODUCT_3  =  PRODUCT_3 ,      
       @PRODUCT_TRIAL  =  PRODUCT_TRIAL ,
       @OVERVIEW   =  OVERVIEW ,      
       @SUPPORT_CENTER  =  SUPPORT_CENTER       ,
       @USER_FORUM   =  USER_FORUM  ,      
       @UNINSTALL_UTILITY  =  UNINSTALL_UTILITY  ,      
       @LICENSE_CENTER    = LICENSE_CENTER  ,      
       @ABOUT  =  ABOUT ,      
       @BLOG  =  BLOG  ,
       @FAQ   =  FAQ  ,
       @CAREERS   =  CAREERS ,
       @PRODUCT_ITEM_1  = PRODUCT_ITEM_1 ,
       @PRODUCT_ITEM_2 =  PRODUCT_ITEM_2  ,
       @PRODUCT_ITEM_3  =  PRODUCT_ITEM_3 ,
       @CATEGORY_ID   =  CATEGORY_ID
       
FROM INSERTED

 EXEC dbo.sp_test_stored_procedure(
@GL_ID ,                 
@WIT_ID  ,                
@SPELL_CHECK  ,       
@HTML_FORMAT  ,             
@PARENT_COMP ,        
@WEBSITE_TYPE ,       
@SHOP_CART ,              
@EMAIL ,              
@DOMAIN ,              
@HOME_PAGE,               
@CONTACT_PAGE ,       
@PRODUCT_PAGE  ,      
@COMPARE_CHART ,       
@PRODUCT_1 ,              
@PRODUCT_2,               
@PRODUCT_3 ,              
@PRODUCT_TRIAL ,       
@OVERVIEW ,              
@SUPPORT_CENTER  ,      
@USER_FORUM ,              
@UNINSTALL_UTILITY  ,      
@LICENSE_CENTER ,          
@ABOUT ,                 
@BLOG ,             
@FAQ  ,             
@CAREERS ,              
@PRODUCT_ITEM_1,        
@PRODUCT_ITEM_2 ,       
@PRODUCT_ITEM_3,        
@CATEGORY_ID
)        

END
GO


 












LVL 10
GlobaLevelProgrammerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Guy Hengel [angelIII / a3]Billing EngineerCommented:
please remove the ( ) around the parameters for the exec procedure statmentalso, you need the BEGIN after the AS for the trigger statement

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
GlobaLevelProgrammerAuthor Commented:
Thank you angelIII !!!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.