Job_status values are listed under sysjobhistory system table in BOL. I'm not sure what the value would be if the job stopped because of a restart. You might...

Is it a domain login that is a member of a Windows group that has access to the 3 databases?

You should be able to disable the schedules for the jobs. Open a job in Enterprise Manager, click on the "Schedules" tab, edit the schedule and uncheck the "Enabled"...

Are the other three databases master, msdb, and tempdb? The guest user is enabled by default in those system databases.

As far as I know, a backup of 32-bit databases will restore on 64-bit as long as the SQL version is the same, but I haven't tried restoring master. ...

Dan,

I can't answer your question about Oracle linked servers, but regarding migrating logins, jobs and DTS packages, scripting is the way to go. MS's KB article about transferring logins...

How about deleting the users from the database? You can do that in Enterprise Manager by expanding "Users", highlighting the users you want to disassociate from logins, and delete....

Have you looked at the Transfer SQL Server Objects Task in SSIS? You could create a package containing the task (configured to copy table schema without data) and schedule...

Is this a SQL Server 2005 database? Does this KB article describe your problem?:

http://support.microsoft.com/kb/922804/en-us

Actually - the standard edition specifically mentions XP pro, Windwos 2000 pro, and the readme mentions Vista. So - that's not exactly true. It runs BETTER on a...

I don't know why the client won't install, but the server components are grayed out because Standard Edition requires a server level operating system.

Grant SELECT on groupB.view to User B and Deny SELECT on Table1 for User B. Do the same for the other users.

This site has a lot of good SQL...

Have the user specify the name of the new table as "dbo.tablename" in the Wizard. He/she can do that by clicking the "Edit SQL" button to edit the create...

Is that the only message you see when you look at job history? I'll guess that it's running an import from AS400. Is that a DTS or SSIS...

I agree with Berto IF you can put the database in a SQL 2000 instance. Upgrade Advisor does a pretty good job of detecting incompatible usage in stored procedures...