sql-dmo odbc sqlstate:42000

• G Foster-238992

  SSC Veteran

  Points: 254

  More actions

  July 18, 2005 at 2:22 am

  #109817

  I am attempting to create a new stored procedure in SQL Server 2000 Enterprise manager.  I have copied the contents of an old procedure.  And then I click on Stored Procedure under the database and click on New Stored Procedure.  I then copy the contents of the old procedure into the New Stored Procedure window.  I have only changed the name of the stored procedure in line 2.   

  And I get the following error when I click on OK to save the procedure.

  Microsoft SQL-DMO (ODBC SQLState: 42000)  Error 170: line 2: Incorrect syntax near 'sp_UpdateTrusIDFromHIERARCHY'

  Any ideas on what could be the problem?

• Logan Fergus

  SSC-Addicted

  Points: 431

  More actions

  July 19, 2005 at 11:18 am

  #575577

  Would help if  you include the whole proc. Must have a syntax error somewhere.