The Oracle installation fiddles with the registry.

Perhaps just a restart of sql server service will do.

I've allways rebooted  the machines after the installation of Oracle 8 just to be sure the...

in .NET you could make a filewatcher that reads the txt,execute

a stored proc with parameter idcard, amount,...

which checks validity & does the transaction when necessary

and returns the result to...

Hello,

Do you have some info on the sql server version,service pack & hotfixes?

*found this whilst browsing the internet, not sure if it applies

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

Sql server is greedy on memory but releases it when other applications need it.

Usually it starts with a "low" memory usage because it hasn't stored execution plans etc in cache....

Have you rebooted the machines?

1 day and 1 hour = 25 hours

Do you have sample data and the wished outcome?

Because if for an odd reason the order of the parameters change (similiar with the order of columns in a table), the call will still work.

procedure myproc @startdate,@numberofdays

-> procedure myproc @numberofdays,@startdate

EXECUTE...

The user isn't system administrator or db_owner?

because the alias has a dot in the name

CASERVICEDESK.ctct AS CASERVICEDESK.ctct_1 ON CASERVICEDESK.call_req.customer = CASERVICEDESK.ctct_1.id

->

CASERVICEDESK.ctct AS ctct_1 ON CASERVICEDESK.call_req.customer = ctct_1.id

have you checked the jobschedule status with

sp_help_jobschedule ?

Have you checked the table for corruption?

You can circumvent it with

DECLARE  @var1 datetime

SET @var1 =CONVERT(DATETIME, SUBSTRING(CAST(GETDATE() AS CHAR(20)), 1, 12), 103)

EXECUTE  u_GetWeekNo @myvar=@var1,@week OUTPUT

CREATE PROCEDURE TimeSheet

(

@company_name varchar(50) = '%',

@employee_name varchar(50)= '%',

@work_no varchar(50)= '%',

@work_type varchar(50)= '%',

@time_type varchar(50)= '%',

@work_date1 datetime = NULL,

@work_date2 datetime = NULL,

@date_operator as varchar(2000) = '='

)

AS

SET NOCOUNT ON /*skip a roundtrip*/

IF (@work_date1...

sp_helplogins

Sure they aren't accessing the tables directly instead of using the view?

Cross database ownership enabled?