Thanks for your input.  I'm off for a week now so will try this on my return. Just didn't want you (or anyone else that replies) to think I was...

Hi, yes they are all individual accounts ie not NT groups are used.

No responses so thought I'd add my own in case anyone else needs to do this. As suspected had to:

backup,detach,de-install,install 2005 Std, install sp2, attach db's

I've used the link David refers to in the past...it works well. However be careful when using it for Win2003 R2 environments as the account you use needs higher privs...

Not sure if it helps but in 2000 you cant easily trigger a job from a file just turning up on your server.  However you can set up a job...

Has it started in the past?

Is it started with an account that has appropriate authority, or has its password changed ??

In your SQL job, youve not coded 'use dbname'   where the dbname is the one your trying to restore have you?

Thanks for you input.  The app provider doesnt think its anything built into the app, but theyre going to take this up a level and investigate further.

The time zone on...

Thanks for your comment.

All I want to do is revoke 'view any database' from Public.  There must be a way to do this in 2005 via Management Studio??

Or...

NETSVC "SQLServerAgent" \\servername /QUERY

Can also use /STOP & /START with NETSVC

(The service name in this query obviously relates to a SQL2000 service, just change the name appropriately)

Have you tried running DBCC CHECKDB with the repair options?

Thanks very much for your input...Have a great Christmas!

Just thought I'd add that rather than re-install SQL if youve no other options, you can just use the rebuildm.exe.  See BOL

Thats useful!

The Ent Mgr equiv seems to be :-

Select the table in Studio Mgr

Click View (at top)

Click Properties window

This Brings up a separate 'designer info' window where you can...

Sorry didn't realise I was in the 2005 forum

Dont really use 2005 yet, have a look at Alter Table it seems to be...