Nice question Anoo. learn something new today. thanks

You can get your hands dirty in SSIS. Following is the link for Stairway to Integration Services[/url] by Andy Leonard

As per your current case, you just need to move the...

If you want to move the data from Server1 to Server2, then you need a connect to that server.

1) Create a link to Server2 link

2) Create a SYNONYM

CREATE SYNONYM myTable2...

hans.pret (4/2/2014)

---

I found the problem.

If this is it I feel like an idiot. I'm no dba so this is still a learning curve for me.

When I setup the cloud server...

ganesh.khuspe_v (4/2/2014)

---

Hi all,

following is my trigger:

CREATE TRIGGER trigger1 ON Table1 after Update AS

begin

INSERT INTO table2

SELECT * from inserted

end

in above...

Mighty (4/2/2014)

---

Andy, can you display the results that you get, including your error and can you tell which tool and version you are using to execute the statements?

As I said...

good one STEVE ... 🙂

Crackinnng :hehe:

The % at the start means your search needs to read every row and look for a match. If you really need that kind of search you should look into...

Wowwww !!!! ... MAY Be ... :hehe:

This means that you have no data with company_id = 28, for the User = 'PO'.

Nice question, refreshed my memories 😛

Another possibility that your...

Thats a million dollar quote, Jeff

Bravooo !!!! :hehe:

nice question. thanks for sharing