Why would it matter if sa owned jobs?

Tough spot. I was thinking of checking @@TRANCOUNT immediately after the call to said "inner proc" and then explicitly raising your own error if things were not as expected after...

Derek Gemmen (4/10/2012)

---

Thank you for the reply. I went back and look to see if there was difference in our code... what I did discover is later in my...

Did you import the assembly? This works fine for me:

[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SMO") | Out-Null

$srv = New-Object Microsoft.SqlServer.Management.SMO.Server("N3011SIM")

foreach ($job in $srv.Jobserver.Jobs)

{

$job.Name + " = " + $job.IsEnabled;

}

If this does...

Stairway to Data[/url]

You could add them to the msdb Database Role SQLAgentUserRole and them make them the job owner of any jobs you want them to be able to modify.

Andeavour (4/10/2012)

---

Thanks to both of you. I've tried it using details from ConnectionStrings and with "Failover Partner", neither seemed to work.

It looks like there's a SQL Server 2008 add on...

sqlfriends (4/10/2012)

---

Thanks, but my question about this is not answered yet.

So, what exactly the step you do for keeping the same name?

By changing the server name, will that leave some...

I recommend using SSIS Package Configurations. Here is a video demonstrating how to get started:

SQL Share > SSIS Configurations

I'll start with the assumption that SSIS is not sending your rows into oblivion without being told to do so. To confirm, are you using the EXCEL connector built into...

You have been given many viable options, all worked for one or more...

I use Policy Based Management with a WMI query (ExecuteWql).

SSIS, being mostly visual in terms of the programming techniques, can sometimes be difficult to get started. This site has been a favorite of mine for a while, and I...

The 1TB in 30 minutes example was leveraging parallelism within SSIS. If you're using a foreach loop then you're making SSIS single-threaded. Since you have a varying number of files...

That's the ticket, but only one query...