Someone circumvented this in a recent post. The trick was to create a view dbo.VW_NOW (name of choice)with as definition: select getdate() as today

From the function use select today from...

I assume it recompiles since there is an explicit command alter procedure.

Have a trace running (sql profiler) at night monitoring for cpu-intensive queries?

Are these spikes or continuous (performance monitor on windows-system)?

It could be a different execution plan between the stored procedure and the extracted sql code due parameter sniffing. The query plan could help here.

To capture the sql-statements you can...

You could divide the delete in a set of smaller batches.

pseudocode

SELECT  1

WHILE @@ROWCOUNT>0

BEGIN

DELETE FROM test where id in (SELECT TOP 100 from test where deletecondition=true)

WAITFORDELAY ...

END

You might search the web on sp_attach_single_file_db. Make sure you have it backed up first.

There must be a more elaborate page than this one

http://www.mssqlcity.com/FAQ/BackRest/ResMaster.htm

Hello,

There is a page about locking in sql server 7,2000 where the key is described.

See http://support.microsoft.com/kb/224453/

Is there anything mentioned in the error logs of sql server?

Has sql server recently been moved/renamed?

Looks like a permission issue. Normal admin functions run fine?

Have a look at

http://support.microsoft.com/kb/328306/en-us

Is the remote server Windows Authentication only?

you still have the line

Set rsLogin = conn2.Execute(SQLQuery2) ?

Do you have experience with asp?

Step 1: create connection

Step 2: execute query

Step 3: check if there are any results .eof

Step 4: process results

Step 5: close recordset

The function IsNull transforms any...

Have you included the function tnull before you call tnull?

You could also change null to IsNull.(Haven't got any empty values yet)

To be really sure you should test if sp_getLogin returns...

El,

The ... was "and so on". The left join causes MATBIT.ITEMCODE to be null if NoSpaces.ITEMCODE isn't found in MATBIT. Actual syntax can differ bases on Access version and how...

Hello,

I divided up in 2 and left out worktask,workrequest (not used?)

select Mileage.users.Uname

, Mileage.UnameFirst

, Mileage.UnameLast

, Mileage.totMileage

, expenses.totExpenses

FROM --calculate total mileage per user,per workcompleted

(

SELECT users.Uname, users.UnameFirst, users.UnameLast

,round(sum(workcompleted.WCmileage), 2) as totMileage

FROM users /*all...