Many thanks - will try that when I get a chance.

Phil

You should backup your database before trying this ...

In Enterprise Manager, just make a design change to the datatype of the varchar field (change it to 'datetime') and save. You...

I would add a WHERE clause to this, along the lines of

UPDATE Fee_Maxima_Benchmarks

SET Fee = CEILING(Fee)

WHERE Fee CEILING(Fee)

The slight amount of extra processing involved is worth it to...

What sort of trouble are you having? Do you want to batch the updates?

Not sure that I follow the process. Do you want to automatically create a record in TicketH whenever one is added or amended in Ticket? Is SeqNbr just...

Your UPDATE statement needs to contain a WHERE clause which specifically excludes all records which have already been updated - and this will, of course, depend on your update logic.

Note...

Try something like this:

select top 3 record, date, country, sales

from (tablename)

order by sales desc

I suspect that your problem occurs before the Select statement has a chance to run on the linked server, so your @error checking never executes.

Your method of error trapping will...

You might like to qualify 'decimal' with 'precision' and 'scale' arguments - eg decimal(9,5) gives you 9 decimal positions per number to play with - up to five of them...

Here's a routine that executes the same command for all databases in an instance.  You should be able to modify it to plug in your commands.

declare @sql varchar(400)

set @sql='select...

I too have seen this error, with queries like

select * from table1 t1 where t1.id = (select t2.id from table2 t2 ... where t2.id = t1.id)

The error occurs when...

Sorry to nit-pick, but just got up at 4am to watch England exit Euro 2004 on penalties, so I'm on the war-path!

Quoting from the original post, the required result in...

Could it be a locking issue (eg table locked for update so other users can't access it)?  Might be worth running Profiler to check.

I'm with warey on this.  Please explain how the data are linked and give an example of the output you are trying to get to.

Can you post the exact error message that you are getting and the circumstances under which it is displayed?