Does the account that runs SQLServer have access to the E partition?

Have you considered saving the Word docs as RTF text?  Word can save documemtns as "RTF text" and open RTF documents.  However, keep in mind that some of the formatting...

I am not sure if this is what you were asking by "what role does a backup device play?" but here goes ...

Backing up to a "backup device" registered...

Have your superiors ever heard of the phrase "don't put all your eggs in one basket"?

Norene

Although I haven't used it yet, SQL 2005 is intergrated with VSS (Visual Source Safe) so that you can do "versioning control" of your SQL sprocs.

Not sure if that helps...

As Dinesh mentioned, you can use "linked servers".  To setup a linked server through EM, do the following

1) In EM, open up the "Security" folder on the database server you want to...

To find out the name of the account running SQL Server Agent, you can do one of the following:

1) Log into the physical database server

2) Under Administrative tools, choose "Services"

3)...

Humphrey:

Can you provide more information?  Are you running the standard version of SQL 2000 or MSDE?  Did you install the SQL client tools (which includes Enterprise Manager )?

The best way to manage this is through roles.  Determine all of the different types of access needed.  Then, create a role for each type of access.  Once you have...

Tlog backups backup all of completed transactions that were made in the database since the last backup.  When you restore a tlog backup, you are performing the transactions again on...

Since you are using the "DISK" parameter in the backup code you should not need to create a "backup device" (FYI - created through SQL EM -> DATABASENAME -> Management ->...

Copy the install directory for MSDE to the local hard drive.  Edit the setup.ini file in this directory to include (under "[Options"]):

SAPWD = {type 'sa' password here}

Save the setup.ini file...

With all of the added SECURITY features in SQL 2005 and the fact that you running on the Internet, I think SQL 2005 is your best bet.

But what Windows user are you logged in as when you run the program?  It sounds like there are issues with reading the registry and I am wondering if the...

Here are two that I found useful:

SQL Server 2005 Best Practices (written by Nanda Kishore of sqlservercentral.com):

http://www.sqlservercentral.com/columnists/nKishore/sqlserver2005bestpractices.asp

Microsoft Technet's SQL Server 2005 Upgrade Handbook:

http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx

Happy Reading!