sys.syscomments

Todd Engen (4/1/2008)

---

Marios,

Some explorer once set off to prove the world was round. Zillions of people said they were crazy, that the world obviously was flat. No matter...

Charles Kincaid (4/1/2008)

---

Anders Pedersen (4/1/2008)

---

...

Wasn't this sort of how SQL 6 and 6.5 worked? At least if I remember correctly those two (and I assume 4.2) bypassed the OS...

Well - I'd write another but I'm already at my 1-cursor per week limit...:)

It looks to me that you're only accessing tables on the linked server. If so - have you considered using OPENQUERY to run this?

Something like:

select * from OPENQUERY(Freedom,'select VD.ID,...

Try this - the functionality of the "ordinal rank" is what you're looking for:

http://www.sqlservercentral.com/articles/Advanced+Querying/61716/%5B/url%5D

If you're talking the old syntax, isn't that LEFT OUTER JOIN?

You've already seen it... right here (sorry - forgot to put in...

Look at that - I just got kicked upstairs to referee...hehe.

Not a problem...Just let me know when to go dust off the black and white checkered polo shirt and the...

Think "beyond the...

Kurt W. Zimmerman (4/1/2008)

---

Greetings all... I had an issue that came up some time ago in my SS 2000 box. I was able to find an extended function that...

Jeff Moden (4/1/2008)

---

To add to what Matt just said... if the server logs in as a domain super-user that can see all the machines and at least some "shares", using...

Backups, log-shipping...

Andre T (4/1/2008)

---

Yes, it certainly is rbar on steroids and I'm familiar with the concept. But when you say it leads to an unscalable system, you are making a...

Lowell (4/1/2008)

---

boy I really agree; It's a stupid Project requirement that all "raw data" is imported from text into SQL Server database, and then the data massaged from there. ...