Thanks all - now that I am back in the office I will give these suggestions a shot.

I did use this article as a blueprint on getting the logins there the first time. I will take another look at this in detail later this week (out...

First, let me start with - I am a fairly new DBA, so I may have missed something...

What I am running into is if I attempt to drop a login...

Greate article on what I need to know as a DBA without getting bogged down in the details.  This is a departure from most things that I have read about...

If you are referring to the fill factor of the index - that is not a column but a separate object.  This is to handle data changes in the index...

OK - I was able to query it under the test login.  Thanks for the lesson and sticking with me through several posts.

J.

I did actually create a test login as well and connected via QA using Test using SQL login.  It still failed when trying to expand the linked server node... grrr...

I don't think that I am being clear...

What I have is:

server1 - with SQL instance companySQL

server2 - with DB2 instance companyDB2

I have set up a linked server pointing from companySQL to...

Yes... I have connected using query analyzer on my PC.

Thanks, but I actually have all SQL users mapped to a single login on the DB2 side.  Under 'security' I did not add any Local server login's and entered login info 'For...

I would not have minded a bit more explaination on the syntax, but that I work around.  I would have liked some idea/example of how this is used though.  Seems...