Management studio is part of the client tools. It is in the same setup for SQL Server.

You are welcome and glad you found the issue.

As a general rule, for production, be sure you have enough space for 2 backups of all databases. These should be on...

The deadlock manager just picks a connection and kills it. There's no "how", it does it.

You need the client to detect that there was no successful transaction and resubmit it....

The sheet name is the table name. A CREATE TABLE statement in an Execute SQL task creates a new sheet.

I'm not sure what you are asking here. Please be more clear with your English and ask a specific question.

It almost appears that you're wanting answers to questions someone has...

I haven't seen these either. Perhaps someone has BackupExec or some other third party product running. Check with other sys admins.

Do you mean execute the package twice? The variables don't maintain from execution to execution.

How often do you need to synchronize? Is it a 2 way sync?

The issue is that VFP uses flat files, the application actually has to use DLLs to read and...

Thanks, Josh. Good work.

You might want to submit this as a script using the "Contribute" link to the left.

Database size isn't relevant. It's # of transactions that have to be sent from one to the other that create the load.

The configuration manager is for managing services. Management Studio is used for creating databases, managing security, etc.

The application needs to trap the error and resubmit the transaction. The deadlock manager kills the connection, so you can't do this in T-SQL.

Do you have logging set up for the maintenance plan? It's on one of the last tabs and you can log to a disk file.

Make sure you have rights for...

Do you mean SQL 2000? REbuildm.exe is on the CD and that will help you rebuild a new, baseline, RTM master database.

If you need to restore, you need to start...

That sounds strange. It almost sounds like some of the SQL files are corrupt. I might uninstall and reinstall the tools.