Is it one table in particular? If so, there might be a corruption problem.

Does the servicepack level of em matches the service pack of the sql server?

Be aware that em...

--sample data

create table reservations

(

RESNO int

,ROOMNO int

,CHECKINDATE datetime

, CHECKOUTDATE datetime

)

insert into reservations

select 1,1,'20080101','20080201'

insert into reservations

select 2,1,'20080301','20080401'

insert into reservations

select 3,1,'20080115','20080116'

insert into reservations

select 4,1,'20071201','20091201'

--gives conflicts

--res1= usually minimum reservation

--res2= usuallymaximum reservation time

select res1.*,res2.*

from reservations...

update mytable

set column1=value1

,column2=value2

,column3=value3

where pkid=recordtoupdateid ?

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.