Elliott W (10/29/2009)

---

When you defined your linked server did you include the instance name? also how did you define your linked server? did you use the SQL Server...

i...

Elliott W (10/29/2009)

---

Enter an alias to the server, specify TCP/IP and first try just using its name, if that doesn't work specify its ip address. Either way specify its...

i´ve my connfiguration like that and my servers are linked...

this is the full error.

"The OLE DB provider "SQLNCLI" for linked server "support" returned message "You have completed the waiting time...

i´m having the following error;

"Mens. 233, Level 16, State 1, Line 0

Named Pipes Provider: Could not open a connection to SQL Server [233]."

any ideas ??

thanks in advance.

server 1 : sql server...

so...how can i...

so i know how to do what i´ve to do.

But i really want to know how do i connect to diferent DB engines from diferent servers.

thanks.

Ok. i´ll evuate the idea of using a aditional local table and a job.

thanks for the advice.

i will stay with the trigger idea and see how it works.

My question now is how should the transact look to insert in one db from another.

insert into...

transactional replication it for large amount of data???

I need to move a really small amount of data from server A to B. that´s what i thought in a trigger.

Thanks a lot. So i guess i have to consider a lot of facts first.

my bad!

Mark Marinovic (10/5/2009)

---

igngua (10/5/2009)

---

Hi! in this edition of noob-weekly-problem (:-D) i need to know how can i update a row with substring from another row.

example;

row1 ...

ok.

the output:

row1----------- row2

aaaaassssssss...