How about those embeded sa passwords within SQL server? For example, DTS package when saved using "sa".  If the sa password is not updated, the scheduled job for the DTS will fail...

1. Is sql server agent is started?

2. go to Enterprise Manager--> Jobs

1) Is the job enabled?

2) Is the job schedule enabled? 

3) Do you see the date&time (your schedule) for "Next...

MS has a KB may give you some details.

How to configure SQL Server to use more than 2 GB of physical memory

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

Your optimization may have reindex option which will consume a lot of T-log space. 

see Table 5 here: http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx

Monitor Database Growth on Multiple SQL Servers

http://www.databasejournal.com/features/mssql/article.php/3339681

You can take the T-SQL part only.  No need to use VBscript.

The core code is:

exec master.dbo.xp_fixeddrives -- for disk space

exec master.dbo.sp_msforeachdb

"select @@servername...

BCP has -F option to skip row(s).  -F2 to start from 2nd row so you do not need delete the first row (column header) each time.

bulk insert has firstrow option to...

There is a column modify_date in sys.objects table which means:

Date the object was last modified by using an ALTER statement. If the object is a table or a...

SQL Server 2005 Webcasts:

http://msdn2.microsoft.com/en-us/sql/aa336323.aspx

sqlskills.com is a good site and kimberly is an excellent speaker.  -- This is not an ad.

http://www.sqlskills.com/blogs/kimberly/

Welcome on board.  Just a couple links for now. 

0. What's a DBA? - An Overview

http://www.sqlservercentral.com/columnists/sjones/whatsadbaanoverview.asp

1. SQL Server administration best practices - This link...

Thank you Mahammed.  The script you provide can give me some helpful hints.

"Last Run Status(Start Date), Next Run Date columns" are needed as I need to monitor the job execution...

In dos cmd line, try to make the bat file work first then copy the bcp command line code to the bat file.

cmd> bcp mytable in E:\SprintBills\Copyof2006Dec08.txt ......

You may need...

You can use BCP (for both SQL2000 and SQL2005). check books online "BCP Utility".

You can create a job to automate this process

job step1: T-SQL: create table mytable (if needed)

job step2:...

A log file can only be shrunk to a virtual log file boundary.  Take a look books online "Shrinking the Transaction Log".  Hope this helps.

Take a look here...

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

Thank you Bill and Morten for your suggestion.

I am wondering whether this approach is good for sa password as the password is plain text...