Thanks for everyone those who have replied

I trying to work thro' SQLBrowseConnect of ODBC.

regards

deena

Fine, Thanx

But then I would appreciate if i could get direct ways

-deena

If i need to find all mssql server instances installed in a network,

I could get this by typing osql /L.

But i would like to list the names of different mssql...

sp_helpdb could be better when compared with sp_databases

since if database size is more than 2 TB then sp_databases could have

some problems.

Exactly

I have opted "append to media"...

hi Elliott,

Thanks for ur reply,

But I have not configured the backup thro' Maintenance Plan,

For this problem

I have handled it by searching in Management->SQL Server Agent->Jobs.

Thanx

deena

Thanx

it works