Did the user who is runninG ALTER LOGIN command has 'sa' access?

Try login to the server as administrator and open the query window and run the ALTER login command...

What about without cursor...to deleted 3 days older  backup....

select @deldate = getdate()- 3   

WHILE @deldate <= (getdate()-@FileDelDays)   

BEGIN   

 select @cmd = 'del  X:\Backups\test_BACKUP_*'+convert(char(8), @deldate , 112)+'*.trn /S '...

One more point...check the fragmentation before reindexing...if there is fragmentation then only reindex otherwise don't do it...

create a sql trace using extended procedure and fire it as a job and write the output to a file...

Upload the trace file to a table and validate dbs accesses...

Take a look the following blog, it may help you...

Full Text Search Adobe PDF files stored in SQL Server...

http://jtkane.spaces.live.com/Blog/cns!1pWDBCiDX1uvH5ATJmNCVLPQ!537.entry

Run sql trace/profiler and perfmon...

In perfmon use the log file counter from SQLSERVERATABASES performance object...

Correlate the log file growth with transactions in profiler...

What...

You don't need detach it..

What is the recovery model of the database?

What caused the db log file to grow 25 GB? Are you taking regular tlog backups of this db?

Why...

If your company can spare/spend money on this you can buy good tools...

If you want to write the code...

You can do using DTS/BCP/LINKED SERVER/OSQL....depends on your servers security requirements...

I use...

SQL server will not drop/clean old/orphaned connections..

If any application is connecting, application should close its connection...SQL doesn't know what the application's request/requirements until it gets it...

YOu can write a script...

I don't see any problem reapplying service pack...

SSIS and SP1 issue...

http://support.microsoft.com/kb/918644

Try using port number with instance name...

Start/All programs/Microsoft SQL Server 2005/SQL Server Business Intelligence Development Studio

I think you can do maintenance against this table...

msrepl_commands table is MS shipped but type = U which is user table...

Why you have millions of rows in msrepl_commands table...looks like...

Lumigent... audit db...and many more.. just google...

http://www.lumigent.com/go/googent/

http://www.red-gate.com/products/SQL_Log_Rescue/index.htm?gclid=CIq-zqCi94kCFRTMggodZFYgWQ

http://www.krell-software.com/index.asp

Read the articles from sql-server-performance.com and sqlservercentral.com related to sql administration.

Check the webcast on MS site...

Read sql forums...