Have you checked this Registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\SystemDB

 on the failing server!!

For Security Purposes Access is superior to MSDE 2000. Period!

The Fact that the mdf can be grabbed and attached somewhere else makes MSDE usless for YOUR purposes!

Bad NEWS on that one   you will have to doit on each Database that you Already have or Create a script  and run it...

EM --> Right Click the Database, Select Properties and then Permissions!

Before you do ANYTHING you need to have a login with Access to those servers!!!

1. Use: This Trick

2. Query the master..sysdatabases table

BE CAREFUL!

I worked with one   a long time ago it was painful when we needed scaling!!

If you are planing to use a...

I have 3 comments!

1. why are you using TOP xxx ... WITHOUT ORDER BY in your sp?

2. why are you using TOP 100 PERCENT if that is not a view ?

3. Do you...

Use the MSDE 2000 Deployment Resource kit

Your answer is Here

how about:

CREATE  PROCEDURE IsJobRunning @JobName as varchar(100) = Null as

--check!!

if (@JobName IS NULL)

 RETURN -1

Declare @theID as uniqueidentifier

--get the ID

Select @theID = A.job_id

 FROM OPENROWSET('SQLOLEDB','dbServerName'; 'Uname'; 'pwd' , 'SET FMTONLY OFF  exec msdb.dbo.sp_help_job') ...

how about:

CREATE  PROCEDURE IsJobRunning @JobName as varchar(100) = Null as

--check!!

if (@JobName IS NULL)

 RETURN -1

Declare @theID as uniqueidentifier

--get the ID

Select @theID = A.job_id

 FROM OPENROWSET('SQLOLEDB','dbServerName'; 'Uname'; 'pwd' , 'SET FMTONLY OFF  exec msdb.dbo.sp_help_job') ...

Use Another job to MONITOR the running time and act accordingly!

Or if you want your own sp:

CREATE Table DataTable (Area varchar(2), Message varchar(100), Store_Num  varchar(8))

GO

Insert into DataTable (area, Message, Store_num) Values ('CN', 'Missing Sales as of 9:59am ', 'BK2345')

Insert...

It really looks that you DON'T need cursors For that!!!

you may want something Like:

SELECT p.ID, Sum(o.OrderAmount)

FROM  People p Left outer join Orders o on p.ID = o.UserId

Group by p.ID

check this out