great thanks to u all for the wonderful contributions. i'd try out the ssis, particularly on charles post. and would get back to u guys if am successful or not.

thanks....

Thanks. this is the case scenario:

Two computers on the same network have the same database (sasDB) present on their respective SQL SERVER. But I want to copy just a single...

i got the stuff rait. thanks to u all.

av a blessed day.

hi, please cud u show a specific example. cos i used the statement u gave, but it doesn't work. thanks.

thanks. i ran and executed the sp_helplinkedsrvlogin, but it's only returning the different logins security i have on the linked server.what i need now is how to use the linked...

this is the error i get when i ran a query against the linked server i created. the name of the linked server is SERVERLINK.

error thus:

OLE DB provider "SQLNCLI" for...

this is the error i get when i ran a query against the linked server i created. the name of the linked server is SERVERLINK.

error thus:

OLE DB provider "SQLNCLI" for...

it's asking me for product name, data source. and i dont know which service (from the various OLE DB Provider) to select. infact i dont understand the process.

Thanks.

GilaMonster, u are such a wonderful person. u are a darling. thanks, already done that.

best regards,

Thanks! but as you can see am a newbie, could you please give a highlight of what i'd need to do so that i can grasp it once and for...

Thanks! but as you can see am a newbie, could you please give a highlight of what i'd need to do so that i can grasp it once and for...

generate scripts? pls xplain better. thanks.

thanks very much for your concern. by the way, what's BOL? can u give me a copy of it to read?

regards

Thanks Gail. The Import/Export data stuff works fine. But am not sure it would when i have tables that are full of constraints, indexes, e.t.c. Like you asked if those...

once again, thank u very much. yes. the destination database exists, but i don't understand what you meant by the linked server. the situations are:

1. copy a table within...