Viewing 15 posts - 14,671 through 14,685 (of 18,923 total)
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
August 5, 2005 at 8:29 am
Yup... can't get married without a ring.
August 5, 2005 at 8:26 am
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(*)...
August 5, 2005 at 8:21 am
You're probabely reading wrong. It's written 4000 not 4 000 000!!!
August 5, 2005 at 8:18 am
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...
August 5, 2005 at 8:13 am
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.
August 5, 2005 at 7:39 am
oops... but now if someone understands it like me he'll know about it both ways
.
August 5, 2005 at 7:33 am
I'd assume serially but then again I know squat about parallelism. So I'll see if others can confirm this.
August 5, 2005 at 7:32 am
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...
August 5, 2005 at 7:25 am
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.
August 5, 2005 at 7:23 am
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...
August 5, 2005 at 7:18 am
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.
August 5, 2005 at 6:54 am
Don't think so. That post is somewhat incomplete at the moment.
August 5, 2005 at 6:49 am
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
August 5, 2005 at 6:41 am
Viewing 15 posts - 14,671 through 14,685 (of 18,923 total)