from sqlserver to oracle:

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

basically:

The same problem was in a thread only a week old. I'll see if I can find it

*can you specify with nolock for

SELECT .....

FROM master.dbo.sysprocesses WHERE hostname=host_name()

we don't want locking to occur in system tables

*for CREATE  TRIGGER Via_Peticiones_TI ON dbo.Via_Peticiones

FOR INSERT

AS

specify SET NOCOUNT ON

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