I thought that might be the answer. Do you know of documentation I may reference that indicates this?

I do not find the G:\ drive added as a resource to SQL2. I checked the Windows registry, SQL Server properties, and the Cluster Administrator.

Both methods (listed below) work on SQL Server 2000 and 7.0. Can anyone explain why one might be better than the other?

Method1:

EXEC master.dbo.xp_sqlagent_enum_jobs 1, dbo

Method2:

select *

from

openrowset ('SQLOLEDB','Server=(local);Trusted_Connection=yes','SET FMTONLY OFF...

Below you will find my enhancement of Dave's stored procedure. This stored procedure will allow us to create SQL Server jobs but have a third party vendor solution run...

The problem with sp_help_job is that one cannot capture its output. When one tries to capture the output into a table, an error occurs because sp_help_job calls other procs...

Excellent! I don't find any documents that talk about xp_sqlagent_enum_jobs. What are the parameters being passed? Is there other parameters that my be passed?

It should have read:

sp_help_job @job_name = 'DLW: Test Merge Job', @job_aspect = 'JOB', @execution_status = 4

IF @@rowcount > 1

BEGIN

SELECT 'IT WORKS!!!'

END

ELSE

BEGIN

SELECT 'IT FAILS...'

END

Here is what I have tried (the sp always returns @@rowcount of 1 whether it has data or not):

sp_help_job @job_name = 'DLW: Test Merge Job', @job_aspect = 'JOB', @execution_status =...

No, I am not issueing a SET NOCOUNT ON anywhere.

I am using TSQL to run the SP.

@@rowcount is always 1 after executing sp_help_job no matter it the stored procedure returns data or not.

I tested the following scenario:

Created Db1 and DB2.  Owner of Db1 and DB2 is sa, meaning all objects will be owned by dbo.  I created application role Db1..AppRole1.  I also...

Please explain.

Excellent point, Allen.  I failed to mention that the new disk group is in the SQL Server group.  I validated this via the Cluster Administrator.

StefanJ's posting is excellent.  However, I need the behind the scene stuff that Enterprise Manager used to create the script.  Then I could add a cursor to get every table...