Are you using the exact same alias in tnsnames.ora and in the linked server?

I'm not sure, but it could be case-sensitive.

Don't cross-post please.

Replies here:

http://www.sqlservercentral.com/Forums/FindPost1027299.aspx

You have to configure your oracle client using a file named "tnsnames.ora" that have to be placed under network\admin in your client directory.

The file should contain something similar to this:

your_server_alias...

I'm sure this will help:

http://www.sqlservercentral.com/articles/T-SQL/62867/

You could, but you would better use DMVs for this task.

In this code sample I captured the top 20 queries by worker time, but you could easily change it filtering...

Having table scripts and sample data would help a lot.

Take a look at the article linked in my signature and post the missing info.

I live in a country where changing job seems to be the only way to raise your salary.

So, yes, I talk about money in the interview and I don't want...

CTRL + R

Look like this one. Duplicate post?

It doesn't make much sense to me.

Can you post table script and some sample data?

Take a look at the article linked in my signature line to see how you can...

What's this? Some Windows' activation key? 😀

GSquared (11/24/2010)

---

You have to be about 8 years old to think it's all that funny, but at the same time, the ancient Summerians probably told the same joke, but in...

WayneS (11/23/2010)

---

Alvin Ramard (11/23/2010)

---

Craig Farrell (11/23/2010)

---

Alvin Ramard (11/23/2010)

---

Depends on what I'm...

Chris Morris-439714 (11/22/2010)

---

Our DBA caught some...

PM: Can you start on it tomorrow (saturday)

Gail: Um, no.

PM: Why not?

Gail: You can't afford my weekend rate. Can you?