Ninja's_RGR'us (9/23/2011)

---

Stefan Krzywicki (9/23/2011)

---

Ninja's_RGR'us (9/23/2011)

---

yes remove the USE 😀

Then the join with sys.indexes won't work. I've never had the need for it, but I'm sure there's a way...

Ninja's_RGR'us (9/23/2011)

---

yes remove the USE 😀

Then the join with sys.indexes won't work. I've never had the need for it, but I'm sure there's a way around it with...

Ninja's_RGR'us (9/23/2011)

---

Ya in compat 80 you can't use a function as a parameter for another function.

Compat mode change the way tsql behaves. The "ironic" twist here is that if...

Ninja's_RGR'us (9/23/2011)

---

Run the code taht fails but from the other db.

It fails because it's in compatibily mode 80.

Alternatively you could just swap DB_ID('ABPMaster') with the db id and the code...

That is 19th century standard practice, it seems barbaric now...

Jim Murphy (9/22/2011)

---

Say, anyone here know how to admin Sharepoint? Things like changing permissions to the calendar and stuff like that?

People are asking me but I don't have a...

If you click the Forums tab on...

Evil Kraig F (9/22/2011)

---

Kiara (9/22/2011)

---

L' Eomot Inversé (9/22/2011)

You can get some mileage (but not much) on some Gaelic from Google Translate by telling it it's Irish; but because the Irish...

jcrawf02 (9/22/2011)

---

Anybody ever go looking for an answer in the Forums, find the perfectly phrased question for your problem, only to find out it was you who posted it in...

Roy Ernest (9/22/2011)

---

ALZDBA (9/22/2011)

---

Roy Ernest (9/21/2011)

---

Apologies in advance for the change in topic... 😀

I want to do a presentation for the SQL saturday that will be conducted in Curacao. Can...

HowardW (9/22/2011)

---

Actually, this is going to be a tricky one to solve. From what I can see, the latest driver that can connect to Oracle 7 (and it actually mentions...

GilaMonster (9/22/2011)

---

Doing the final checks and tweaks on Jonathan's book.

Keep this lot in line? How would I...

Gianluca Sartori (9/21/2011)

---

Stefan Krzywicki (9/21/2011)

---

That sounds pretty funny. I'd think if it were really the best, the consultant would be able to say "Oh, you just have this configured wrong,...

Yeah, I was worried about...

Jo Pattyn (9/21/2011)

---

not sure if there were servicenames in 7.2, it is probably a SID.

What are the results of oracle basic connectivity testing?

in command prompt:

tnsping myoldandtrusty

->shows location of the oracle...