Sunil,

  I would agree with Ankush if your SQL Server is on the same machine that you want the batch file to run.  SQL Services will likely not be started...

I've never worked with PRODAS, but you might look at the DBMS/Copy tool here.  It supports PRODAS files and looks like it could export to something supported by SQL.

http://www.dataflux.com/dbms/

You can take a look at this article:

http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3BQ310834

and this one has info on deciphering waittypes:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;822101

It would be simplest to send the mail from within the same procedure that updates the password, however, that means notifications wouldn't be sent if the table were updated directly.

A...

My mistake, I thought he was asking for a way to do it WITHOUT coding.

I agree that your solution is perfectly sound and I...

We use a view, similar to this one:

CREATE VIEW MostRecentBackup

AS

select   a.database_name as 'DatabaseName', max(backup_finish_date) as 'BackupDate'

from     msdb..backupset a

where    a.type in ('I','D')

and exists

  (select *

   from   master..sysdatabases b

   where  a.database_name...

I'm not quite sure why you think creating a job means coding.  Unless you really like writing T-SQL, creating a job in Enterprise Manager doesn't require any coding.

Since you are...

Hi Suresh,

  SQL Server 6.0 was not supported after NT 3.51.  I know there were some issues with installing anything other than the default sort order on NT 4.0, so...