That works exactly like I wanted. It is a bit slow (it took 18 seconds to complete with only one job running), but it will work.

Thanks for your help!

I've done this before (log shipping from an instance of SQL Server on one cluster to an instance of SQL Server on another cluster).

Since Microsoft clustering is a share-nothing...

I already checked sysjobhistory. It only updates that table after the job completes. I even tested it by runing a job and checking the status in sysjobhistory, which didn't change...

Could you give me some more detail on how you do this, wildh? I am currently doing the ActiveX script to copy an empty template over the end excel file,...

quote:

---

Set a limit on the max file size of the current file to force all your data to the

new file immediately.

I am...

SQL Server Does Not split the I/O between the transaction log files. It writes to them sequentially, filling the first one, then the second. There is no performance to benefit...

I am basically executing a SP from a web page. That stored procedure contains a line like EXEC msdb.dbo.sp_start_job @job_id = '190C3A02-E8D6-43B7-95CD-003F2F034B9C'

The user is is executing under is not a...

This still doesn't work. When I try it (from an account that is System Administrator on the SQL Server) I get the following error:

Error Type:

Microsoft OLE DB Provider for ODBC...

Duh. I don't know why I couldn't find this earlier. Thanks for the help!

I would be very nervious doing this. If you really have two different SQL Servers accessing the same SAN drive and using the same master, etc. databases, the server names...

The server is on SP2 (ver 8.00.524) - It's a little behind due to an application requirement.

Don't you need to set allow updates to system tables on before changing to C2 security? IE:

USE master

EXEC sp_configure 'allow updates', '1'

RECONFIGURE

And then for good measure, turn it back off...