*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

There is an article about it:

http://www.sqlservercentral.com/columnists/bkelley/sqlserversecuritydealingwithantivirusprograms.asp

from the books online

The changes specified in ALTER TABLE are implemented immediately. If the changes require modifications of the rows in the table, ALTER TABLE updates the rows. ALTER TABLE...

There could be too many statistics.

sp_helpstats shows the statistics on the table.

(n)textfields or (var)char fields?

If varchar you can write an user defined function

Either with the function ASCII (returns int value of the first character)

or with calling REPLACE  x times.

Try

You need to check the configuration for the service. Go to

Services(from Control Panel or Administrative Tools -

depending on your OS).

Go to the sqlserveragent service and view the properties for

the...

*rewritten with joins

*group by takes care of distinct

SELECT B.BookingID,

ISNULL(UPPER(C.CustomerSurname),'') AS CustomerSurname

FROM tbl_hp_bookings B WITH (NOLOCK)

INNER JOIN tbl_hp_bookings_transactions BT WITH (NOLOCK)

 ON B.BookingID = BT.BookingID

 AND BT.TransactionTypeID <> 1001

LEFT JOIN tbl_hp_customers C WITH...

*convert the int properly with convert(varchar(length_of_field),code)

*another way of updating

UPDATE OccRadiology

SET OccRadiology.Ipsil= goodcodes.code

FROM OccRadiology

INNER JOIN /*only the ones who match*/

(select convert(varchar(30),CodeLookUp.Code) as code /*ipsil is varchar*/

FROM CodeLookUp

WHERE CodeLookUp.CType = 93

) AS...

That's odd.

How do you start sql server agent? From services.msc ?

What sql server version are you using?

Does the path in services.msc ->services-> SQLSERVERAGENT path to executable is correct?

Mine is sql...

When the popup with the change script comes up, there is a checkbox automatically generate change script on save

This is a more complete version of

http://support.microsoft.com/default.aspx?scid=kb;en-us;329332&Product=sql

-> http://support.microsoft.com/kb/839279

Either restricting their rights at database level to only allow selects and/or having a check on your query builder.

Do they connect to the database only by your application (application role,...