Let me explain better my requirements.

There are 2 servers. A remote one which has Oracle as dbms and the local server which has SQL Server 2005 as DBMS. These 2...

The problems is making the copy on my local server which is too slow.

My requirements is to copy the whole data.

Hello Daniel,

thank you for the reply.

I have followed the first approach but my problem was that it was not working. The article here is somewhat confusing.

To solve this issue they...

You're Right!!!

Thank you.:-)

Hello Jason,

Thank you very much.

The script generated from your code is perfect.

😉

I mean that the agent is runnning. No logs or other errors.

Anyway, I have updated windows server and also rebooted the server and the scheduling meccanism seem to work now.

Thank...

Rarely i...

Paul White NZ (12/15/2010)

---

evald (12/15/2010)

---

...I'm just trying to say that if the order clause is not working in some cases for some reason than its useless and confusing give the...

I HAVE UNDERSTOOD THIS. I'M TRYING TO SAY THAT SINCE DOES NOT ENFORCE ORDER, IT IS CONFUSING!!!

Regards

GSquared (12/15/2010)

---

I hate to say this, but it looks like ego is getting in your way here.

"Yes, even the bugs are well documented." Really? If you honestly consider...

GilaMonster (12/14/2010)

This is clearly documented. From Books Online:

When ORDER BY is used in the definition of a view, inline function, derived table, or subquery, the clause is used only to...

GilaMonster let me explain with a simple example because i'm not understanding you.

Suppose the view is created like this(which is the same as mine except that i'm using also some...

Yes of course, but i mean if the dbms is accepting a sql statement i'm expecting that it works.

This kinds of...

I have used the top(99.999) trick read here http://cf-bill.blogspot.com/2007/01/sql-server-order-view.html

Since this view is not used by other views seems it works.

Thank you.