Do you mean that you have closed the window that was restoring the database if so your restore would have got failed and the database will be seen in the...

Haven't you try anything with DTS packages?

Your agent service does not start because it tries to make a client connection within the locla machine. And you say that you are not able to coonecto to the...

Have you given the right port number for SQL Server. Check if the port number specified is also correct.

When you mean to say link to sql server txt files. Do you mean this.

Read the contents of the file from a text file and write to to SQL...

Enable shared memory through SQL Configuration Area Manager. Then you should be able to connect to the SQL Server using ODBC.

You can set affinity to a particular process in your system but you cant force the processor to attain 100% utilization.

Give the user read only access to msdb database. Also there are few procedures that is oriented with jobs for those procedure check and remove execute permissions that update/modify job...

If its SQL 2005 database you can go for data partitioning else if its 2000 my suggestion is to archive the table that has history of records keeping only the...

This looks weird. Try adding the user using TSQL and see what it says.

The profile is not properly created. Try executing the procedure and check whats the error it throwing.

Does the account under which the jobs runs have enough permissions to the folder. Also is it connecting to a remote server to access the folder. If so what account...

In 2005 you have something called as file storage type and server storage type. If the DTS is stored as file storage type the owner of the SSIS package can...

That is a SQL-DMO code. You can't directly place the code in SQL engine. You have to place the code in a vbs file and call the vbs file through...

IIS is not required unless you are planning to use reporting services.