One thing to add, hopefully this will help. If you check the value is sysjobservers.last_run_outcome you can determine if the job has failed or what it's last status was....

As promised. Here is the link to the 4 gig limitation

http://support.microsoft.com/default.aspx?scid=kb;EN-US;301913

Here is the KB for the MDAC issues with SQL Server

http://support.microsoft.com/default.aspx?scid=kb;en-us;827452

Here is another issue that I came across...

I'm not sure if these will fix the problem

1.There is a known issue with MS Packagers and 4 gigs of free space on the system drive. If you have exactly...

Update. This is still an issue however I have recently located a hot fix release via MS http://support.microsoft.com/?kbid=838460

Hopefully this will help anyone that runs into the same issue.

Glad that I could help.

Using the options that I sugestted, that is the only solution that I have found to work. Once you have your data copied to a new DB you will need...

Grasshopper,

Now that you have the database is emergency mode try to execute a query via QA to confirm that you can access the data. If you can then you can...

Try this as an option if your restores are failing:

1. First you must modify master to allow the update of system tables. This is done by executing the statement below...

One option would be to execute the store procedure sp_removedbreplication from query analyzer. Books on-line has the references to this SP.

Johnny Johnson

Open Software Solutions, Inc.

Andy,

Thanks for the quick post. Our application need the sort order due to it's business rules. Believe it or not I tried to call and of the nine numbers I...