Yes, it only seems to work if the login is a local login meaning a sql authenticated account or an individual AD domain user. But when I try to use...

I am still getting the error after enabling db cross chaining

I should mention that the db2 database is using sql server replication and it is a subscribing database. Would cross-chaining affect replication?

no joins, simple select query. Company policy unfortunately.

However, I really want to know what is going on behind the scenes in Sql Server in this situation, specifically the server with...

Awesome that worked! The missing piece of the puzzle was creating the login with my credentials.

You can use the TOP clause on the outer select, not the inner select.

Now, how...

Thanks for the script, I did try the LDAP string that was returned for the script. I still get the same error. I would think I would have permission since...

I replaced the double quotes with two single quotes. I also did a TOP 10 and I am still getting the same error

Msg 7321, Level 16, State 2, Line 10

An...

I actually found a good solution using powershell. You can use powershell as a type in the job properties and use this code.

if ( (Test-Path -Path "C:\temp\testdb.bak") -eq $false)...

Was there any determination on the query syntax?

Can you send your actual command, it looks like you were using the command from the article. I'm just wondering if...

I have tried double quotes and two single qoutes and no quotes. I get the same error. I tested the ADSI linked server and it returned successful.

SELECT * FROM OpenQuery(ADSI,...

Thanks, that gave me what I needed, but I still get an error. I created the ADSI linked server successfully, but when I run the query, I get the following...

in a large corporation, nothing is easy to find, even finding a network resource would be difficult and time comsuming.

Is there a way to determine the fully qualified AD domain....

Elliott Whitlow (6/7/2011)

---

Not that I know of, but have you considered using the ADSI provider to query the data as a linked server?

On most of my systems I disable xp_cmdshell...

I can't figure out what to do with this portion of Nigel's script. If I put it in the script portion of the ActiveX Script Task, it does not parse....

Employee ID's are currently loaded with SSIS package. However, company is going through merger and employee id's are...