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?

*DROP TOP 100 PERCENT

*I've rewritten it a bit. Check if the outcome is the same.

SELECT

 dbo.tblOrganization.OrganizationTitle AS Organizatie

, dbo.tblInstallation.InstallationTitle AS Instalatie

, dbo.tblForm.FormTitle AS Formular

, dbo.tblParam.ParamTitle + '[' + ISNULL(dbo.tblValue.MeasUnit, '')...

Have you declared all sizes in your stored procedure?

Like convert(varchar(mylength),my variable) instead of convert(varchar, myvariable)?

if you know the maximum length of the column

select myfield

from mytable

order by convert(char(maxlen),myfield)

all those brackets are confusing me

but the subselect in ON=

LEFT JOIN    [SELECT description, id, type, call_req_id, last_mod_dt FROM act_log] ON call_req.persid = [SELECT description,id,type,call_req_id,last_mod_dt].call_req_id) 

looks like a weird construction