I think that you need one more BEGIN - just after WHILE:

While (@i < @intRecurr)

BEGIN

Set @intFrequency = (@intFrequency * @i)

Set @dteMaintStartDate = DateAdd(Day, @intFrequency, @dteMaintStartDate)

Insert Into MaintenanceDetails (EquipID, ScheduleDate, MaintDescription)...

See BOL ---> UPDATE statement ---> Using the UPDATE statement with information from another table

I'm not sure if you use SQL 2000 or SQL 2005.

If you work with SQL 2005 you should explore the SSIS.

Also run DBCC UPDATEUSAGE - see BOL ---> Upgrading the Database Engine.

Check for bloking using the "activity monitor".

If your machine has several processors you may have trouble with the "max...

What do you mean by "doesn't seem to work"?

You can also try to install using the graphical interface - it is easier there to change the file locations.

Voir

http://www.sqlmag.com/Article/ArticleID/45921/sql_server_45921.html

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

Usually in such a case I use the "tuning" template provided by the profiler. I set up a "server-side" trace and run it during the working hours, to capture...

I think that

http://www.sqlservercentral.com/articles/Administration/3243/

is helpful...

However you should take steps to minimize deadlock occurence - BOL ---> Minimizing Deadlocks may be a good starting point...

Check the stored proc's code for collation related issues.

BULK INSERT worked for me. My test file contains a single column - date values formatted like "01/08/08 03:10" (dd/mm/yy hh:mm) which I imported in a table with a smalldatetime...

Try the "Full-Text Search" chapter of the Books Online.