Ask your DBA to setup linked server to Oracle and then you can query Oracle database just like query SQL Server database.

http://support.microsoft.com/default.aspx?scid=kb;en-us;280106

Use maintenace wizard.

I am confused how can those companies save money by importing "H1B" worker, especially in IT industry? Some of my friends worked with "H1B" and received same benefits and compatible...

MSDE only supports database that is less than 2 GB.

sp_refreshview

Double click your maintenance plan --> Reporting Tab --> Check "write report a text file ...", Rerun your job and review the report to see whether you can capture any...

sp_helpindex yourtablename

It sounds like account issue, what type service account do you use to run SQL Server Agent and what permissions does it have to the share drive in AS400?

Free some disk spaces in the drive your log file resides and restart SQL Server, If the database is still in suspect mode, follow Kishore's suggestions.

"NOTE: At the time of...

You can't restore records from backup. You have to restore entire database.

With third party tools, you should be able to recover data from the transaction log or transaction backup...

sp_helprole

EXEC sp_helprotect NULL, 'YourDatabaseRole'

From EM --> Right Click your database --> All tasks --> Detach DB --> Make sure all connection to DB is 0 and Click OK.

Move th elog file to new...

Open a case to Microsoft.

Which MDAC version do you have in that server?

Check to see any trace flags eanbled.

dbcc tracestatus (-1)

Never see this type message, Do you use third party tools to admin/monitor your SQL Server?