You can have the AccDB pick up and send the table to the end-user with the docmd.sendobject command as an excel spreadsheet. You can even fire the access using the...

Microsoft Knowledge Base Article - 319951

HOW TO: Transfer Data to Excel by Using SQL Server Data Transformation Services

http://support.microsoft.com/default.aspx?scid=kb;en-us;319951&Product=sql2k

From the article:

If you select the drop and re-create the destination table option,...

Couldn't see the screenshot......

A couple of questions....

Are you trying to back up all the databases under 1 plan?

If so, are all databases in "Trunc. Log On Chkpt." mode?

Are you attempting...

No. Just go multi-user.

Check your timeouts.

Also how are you connecting to the server? Named pipes? Try changing to/adding TCP/IP. Are you connecting using the IP address or a DNS name? Check your DNS...

Do you have a spare/different SQL server? Try restoring the DB on that server. See if it looks okay. Then detach the database on server B and reattach on Server...

Check KB articles:

http://support.microsoft.com/default.aspx?scid=kb;en-us;308886&Product=sql2k

http://support.microsoft.com/default.aspx?scid=kb;en-us;811205&Product=sql2k

Missed something small but important, the database name.

ALTER DATABASE dbname SET SINGLE_USER WITH ROLLBACK IMMEDIATE

Also, don't forget to separate the commands with a "GO" if you are trying...

Thanks for the update.

I'm not using the e-mail code yet. I'm trying to build up a stats database that get DB sizes, disk size, last backup (log and transaction), recovery...

I agree it is a great script.

I did minor mods to to handle checking remote servers. Also, if you fire it from the...

Sorry - my bad. I only had ASCII 0-127 hanging on my wall. I just printed the 128-255 now. The best place I...

The double pipe "||" is a concantenation character in Oracle (and some other DB systems). It is probably being recognized as a special character and translates out as ASCII Char...

I'm working on a procedure that collects all this data into one location so I have to use your select statements.

Just wanted to mention that I've come up with a...

Knowledge Base article 128809

http://support.microsoft.com/default.aspx?scid=kb;en-us;128809&Product=acc97

This is because of index(es), or lack of, on the SQL table. If you can't alter the SQL database to put an index on the table then...

ALTER DATABASE Northwind

SET SINGLE_USER

WITH ROLLBACK AFTER 30 SECONDS

Did they change this in SQL2K from SQL7? I ran it against my SQL7 server and got the following message.

Server: Msg 156, Level...