Isn't there something that needs to be done on the boxes themselves since they are different domains? Could there be a syntax to add the Server Name, User ID and...

I'm not familiar with PowerShell. Is there anywhere I can go to get instructions on how to do this via SQL Powershell?

Ok, Excellent... thank you! 🙂

1 down... 🙂

I'll be running it from a master server... atleast I'm trying to 🙂

Turns out after several conference calls and temp fixes it was the Data Direct Driver that needed to be updated for 64 bit servers. In the mean time I found...

We are already using OpenQuery. We've also noticed that when multiple jobs run using the same linked server name, it hangs, we've had to adjust timing on these b ut...

I do know the job name(s) however i do not want to open each job to add the step.

Let's say very simplistic example) I have Job called MonitoringThisJob

I want to...

LIke I stated earlier, I'm not a developer, I'm a DBA and passing things through and changing code from 3 different sources, is not my forte.Unfortunately, I did not design...

I replaced all the cursors named error with one called login but still not sure how this is supposed to work"

/****************************************

Script Made by Lester A. Policarpio

For questions and clarifications feel...

Ok. Thank you!

I found this online today

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/8e3990bf-be08-418e-8c3f-60047cf5fda7/

Great! Let me see what I can figure out... thank you so much!

I found this script here for something else and it works...

Thank you so much for your help! 🙂

DECLARE @TEMP TABLE

(

ID INT IDENTITY(1, 1),

OBJECT_NAME VARCHAR(100)

)

INSERT INTO...

I get the result set of what is inside the table twice. The temp tables are still there. 🙁

I was unable to see any code in the original post from you to run on my end. But I thank you very much for reposting it. Here is the...