Job fails

• bdh-550389

  Old Hand

  Points: 380

  More actions

  July 17, 2008 at 2:05 am

  #129927

  Hi all

  Every night I am executing a job and it fails. The job is this SQL statement:

  INSERT INTO database.dbo.Customers

  SELECT "Name", "Address", "Address 2", "Post Code", "City", "Phone No_", "Telex No_", "No_" FROM "Second Database"."dbo"."Customer"

  WHERE "No_" NOT IN (

  SELECT database.dbo.Customers.Customer_ID FROM database.dbo.Customers

  ) ;

  The error I receive is this:

  Message

  Executed as user: Domain\sqlservice. Incorrect syntax near 'Second Database'. [SQLSTATE 42000] (Error 102). The step failed.

  The user Domain\sqlservice is SA. When I execute the same statement in Manegement studio I don't get any error.

  Could you please help me?

  Regards

  Bo

• stephen.christie

  SSC Eights!

  Points: 895

  More actions

  July 17, 2008 at 2:55 am

  #844209

  Good Day,

  Try and put square brackets "[]" around Second Database, it could be the space between the two names that is causing the issues.

  You can also try and remove the "" if you are running this through a SQL Statement.

  Regards

  Stephen

• bdh-550389

  Old Hand

  Points: 380

  More actions

  July 17, 2008 at 3:30 am

  #844221

  The [] brackets worked. Thank you

  Bo

• abmore

  Hall of Fame

  Points: 3628

  More actions

  July 17, 2008 at 4:22 am

  #844246

  While specifying th Four naming part its a good habit to specify them with square backets ...

  [Server Name].[Database Name].[Schema].[Table Name]