I dont have offical permission to shrink the log file..............

so how can i do that in a different way

hi,

this may help u

but this works such as if one of the column in a row is a zero , then it will not count that row

update table1

set...

Hi

for this scenario please use linked server concept

EXECUTE THIS in server A

STEP1:

exec sp_addlinkedserver 'name of server B', 'SQL SERVER'

STEP2:

EXEC sp_addlinkedsrvlogin

@rmtsrvname = 'name...

this may help u ...

plzzzz try this. it is working

select * from information_schema.columns where column_name like '% %' and table_name like '%give the table name>%'

ya john your are Absolutely right,

if you dont use ssis

it is better to use linked server concept to retrieve data from another server

step1: add linked server

step2:...