What about using replication? You can install SQL Express on their machine and setup transactional replication making the machine a subscriber. They would have a read-only copy of the database...

DTExec is referring to the command-line utility used to run SSIS packages. That being said, I believe there are a lot of caveats for 64-bit SSIS packages, as not all...

What permissions does your normal account have on the MSDE instance? It could be possible that you don't have permissions to see the SQL instance, so it cannot give you...

What kind of window for off-peak usage hours do you have? I would suggest scheduling jobs during off-peak hours to complete the following:

- rebuild all indexes (since your database is...

Don't forget about SQL Agent jobs, maintenance plans, DTS packages, reports (if used), extra stored procedures/functions created...

I am not sure if I understand where you are having a problem. Are you having a problem running the stored procedure in a query window or through a program?

How did you delete them from replication?

You should be able to use system stored procedures to remove the subscription. Just remember the sp needs to be ran from the location...

In that case I think it is going to be tough either way you design it, as there is going to be contention with multiple requests trying to read/write to...

Well, since Windows Server 2003 is going on 7 years old now and SQL Server 2000 is not even supported without an extended support contract, I would suggest upgrade whatever...

That is an option, but I know a lot of environments will not allow that because that negates any possibility of real-time protection.

Can SQL 2000 Personal Edition even recognize more than 2GB or RAM?

Not sure. I know we used to see a lot of contention of resources and file handles with Symantec, but I believe there were some exclusions that were left out.

What...

As your OS is using one of the drives it is going to be hard to get any kind of great performance (in my opinion) as you will have some...

I agree, going with 64-bit for the OS and SQL is the best option if possible. 32-bit SQL can access more than 4GB of RAM with AWE enabled, but only...

Is the OS you are running now and are going to be running on the upgrade 32-bit or 64-bit? If it is 32-bit, then you will need the /PAE switch,...