My company is required to hide the server's application or purpose. We tend to name them in related groups, comic book characters, cars, amusement parks, etc, and sometimes use suffixes...

SQL Versions, # of servers:

2000 - 17, a few outdated phone system and medical reporting apps.

2005 - 50, majority are 3rd party applications that don't support 2008...

This years TechEd seems pretty sparse for a SQL DBA. SQL Sessions are sparse today and a lot of marketing fluff even though R2 just came out. Maybe that's because...

I've yet to see either users of Excel, Crystal, Reporting Services, Cognos, or any of the myriad of other reporting tools, create optimized queries just by using the reporting tools,...

Did the Microsoft JDBC driver get installed where the 3rd party application can access it?

If not, you can download it from :

http://www.microsoft.com/downloads/details.aspx?FamilyID=C47053EB-3B64-4794-950D-81E1EC91C1BA&displaylang=en

If the Oracle login id used by the linked server is fixed, it may not have access to "PBWLMS" tables. You will probably need to recreate the report since the...

You will want to install the Oracle Client on the SQL Server.

You will then want the Oracle DBA to create a login id and grant it access to the view.

Then...

Have you tried connecting by the IP address instead of the computername?

I would agree with Brandie in that's it's experience you'll want after getting a cert. Volunteer to get that experience under the belt even if it's not strictly database work....

I was probably in that session also so I can relate.

Out of the 6 sessions I've seen so far at PASS, 4 have been superb, 1 was interesting but presently...