Getting error!!!!!!!!!

• lucky-80472

  SSCertifiable

  Points: 7793

  More actions

  October 25, 2005 at 11:36 am

  #89806

  Hello All,

  I am trying to execute a query in QA and getting this error:

  [Microsoft][ODBC SQL Server Driver]Syntax error or access violation

  I have created my own test database in the development server and assigned "System Administrators" fixed server role to my NT user name.

  I am creating a table and wrote a stored procedure to get the information. While executing the stored procedure, am encountering the above mentioned error. Table is created in my test database.

  CREATE PROCEDURE test

   AS

   {

          select * from msdb..sysjobs

   }

  any help would be appreciated.

  Windows Server 2003 with SQL Server 2000.

  Thanks

  
  Lucky

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  October 25, 2005 at 11:37 am

  #599885

  CREATE PROCEDURE test

  AS

  select * from msdb..sysjobs

  GO