Hi I managed to get around doing what I needed by splitting out the hour and minutes, checking the length and prepending a 0 where required. This is not...

Thanks that did help I had been having issues trying to perform the update but then remembered I had a trigger on the table, I disabled that, performed the update...

I get the same error - I am looking towards a firewall issue seeing as the linked server is in a DMZ

no because it is a linked index server via a link to another sql server

SQL1 -> SQL-2 -> Index

Thr current method returns a recordset it's just I can't get it...

hi the query is

Declare @searchPhrase nvarchar(4000)

SET @searchPhrase = 'Select * From openQuery(WebIndex,  ''Select Characterization, Path, DocTitle from Scope() Where FREETEXT(Contents,''''council'''') ORDER BY Rank'')'

INSERT INTO

  #tempSearch

  (

  [sort_order],

  [rank],

  [app_code],

  [application],

  [path],

  [filename],

  [data_pk],

  [summary],

  [authorised_date],

  [audience]

 &nbsp

 execute...

Thanks I looked at the job and added a default user account for the job to run if the user running the job is not in the list and now...