Have a look at the audit & performance tuning articles on

http://www.sql-server-performance.com/articles/audit/main.aspx

I don't have much experience in Oracle but you could start with the migration documents of Microsoft

to sql server

2000: http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part2/c0761.mspx?mfr=true

2005: http://www.microsoft.com/sql/techinfo/whitepapers/MigrOracleSQL2005.mspx

Importing views, stored procedures, functions isn't straigth forward because different SQL-dialects (TSQL vs PL/SQL ...). Have you tried copy objects?

The following link is the microsoft guide on how to migrate...

Looks like some job is causing troubles.

Have you an overview of that jobs/programs... are accessing the server at those times?

Does it occur daily? (perhaps a profiler trace might help to...

Have you checked your hardware because your database has quite some errors.

Other suggestions:

http://www.sqlservercentral.com/Forums/Topic477115-5-1.aspx#bm477258

Who or what is taking the backups? (sql jobs or third party)

If you run a dbcc check... with allow repair data loss, then there can be dataloss. In your case probably 2 records.

With

use mydb

select OBJECT_NAME(.....) you can find out what...

If your transaction log is full, the whole last transaction will rollback.

Please disregard my previous post, i have no experience with web security.

You could build minor security checks (login valid,..) in the stored procedures before they do their intented job to...

I would go with a webservice.

1)It provides abstraction in case

*you want to alter the stored procedure, change db, ...

2)No login "visible", the security context of the webservice calling...

After you change the recovery to Full, do you take a full backup/differential backup before taking the transaction log backup?

or you could use a script that uses

the stored procedure sp_start_job

if there are no dependencies.

Any option to validate the transactionlog before applying?

(RESTORE VERIFYONLY .... )

As far I know linked servers don't expose sublinked servers.

Linkedserver1 with sublinkedserver3

Server 2 can't query Linkedserver1.Sublinkedserver3.dbo.table1.

Linked server1 could create a view MyView based on sublinkedserver3.dbo.table1

I'll try to answer this on Tuesday.

Does a basic query works?

It could be that distributed transactions ain't configured correctly.

(Are the server machines windows 2003?)

*spGetNewExhibitJSubContractorsDetails is located on the external system...