Thanks Lowell.

That is exactly how I believed it to work. I have somebody wokring on this issue in SQL 2008. However, they are using "msado" via Excel to...

All backups and reindexing jobs were completed Friday evening.

I looked at the system log, which logged the fact that the D: disk was at or near capacity and warned that...

Another key thing to do is...once you have installed SQL Server on your server, you should move tempdb to the SAN array.

You can not uninstall an SP in SQL Server.

I would have done the same as John stated.

But, what is the reason that they want to go back to SP3a?

Al

How did you move the database?

Did you backup and restore over to the new server?

Or did you detach, copy the files and attach them on the new server?

I did the...

Our issue is going to be more clouded than that, I think.

In more detail...

   After the user(s) enter orders into MySQL outside of our firewall, we want to run a...

Sure, let me know how you make out with it.

Thank you,

Al

So, you use MSAccess to insert and delete in the MySQL database?

Have you tried using SQL Server 2000 to do so?

We are able to get data from a MySQL database 3.5.1 into SQL 2000 too.  We haven't had the need to get it into SQL 2005.

Our question is this:

Have you...

Run this script to create the output you need to copy security.

SET NOCOUNT ON

SELECT 'EXEC sp_addlogin @loginame = ''' + loginname + ''''

,', @defdb = ''' + dbname +...

Are you on SP1 or SP2?

I read that although you set up email in SQL 2005, there is a bug which is supposed to be fixed in SP2.

So,...

Or once you run the "sp_who2" command, you might find that the SPID performing the restore is being blocked?

Oh, and John is absolutely correct in saying that you should run your deltes in smaller batches to help control your problem.

James,

You can run the following...(this will truncate the data within the log file)

backup log yourdatabasename with truncate_only

Then run this...(find the log database file name in the database properties, and size...