Do you have access to those servers?

Did you try using the sa account instead of trusted?

Noeld I'm getting close... I was only missing the data source this time

Yup... can't get married without a ring.

It's great if you only need an approximate number. (let's say you want to monitor the tables' growth on the whole db as a monthly task without doing select count(*)...

You're probabely reading wrong. It's written 4000 not 4 000 000!!!

1 - Don't use the replace function, it will update good data too eg : Some_name will become somename.

This should solve your problem in case you need to redo this...

I think Sushila meant :

Update TblName

set col1 = IIF(col1 = '_', NULL, col1)

I'll see if I can come up with a way to generate the statements automatically.

oops... but now if someone understands it like me he'll know about it both ways .

I'd assume serially but then again I know squat about parallelism. So I'll see if others can confirm this.

Dream on... he still didn't give me the ring...

Anyways I ave already asked him to check the thread out. He must be busy at work... for once this week...

This way, the db can make better use of short circuiting, so that the second condition is not evaluated if the first condition is TRUE.

check this out, it'll return a row .

create table a

(b int not null)

select * from dbo.SysIndexes where id = object_id('a')

drop table a

What tables do...

Why not add an err handler in the vb code that runs he queries? You could then log 'em to the server or on .log file.

Don't think so. That post is somewhat incomplete at the moment.

Yup, I was trying to make it work without the self-linked server but looks like there's no way around... unless we ask Noeld

Looks like we do .