Here is an interesting new technical article about recompilations:

http://www.microsoft.com/technet/prodtechnol/sql/2005/recomp.mspx

This article compares the SQL Server 2005 behaviour with the SQL Server 2000 behaviour. Here is an interesting quote about this...

I mentioned the article 838166 because you can download from there a hotfix for SQL Server 2000 version 8.00.878 (this hotfix is later than SP3, which is 8.00.760).

You cannot uninstall MDAC;...

You have encountered a bug in SQL Server or in MDAC, possibly this one:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;299575

Update SQL Server to the latest service pack, update to MDAC 2.6 SP2 or later. If...

Corie,

An indexed view cannot be used in this scenario. You will get an error like the following: "Cannot index the view '<<view name>>'. It contains one or more disallowed constructs."....

Do you have any triggers on the destination table ? If yes, they may be the cause of the slowness. Tell us what the triggers are doing (and how), and...

This is documented in BOL in the following topic:

http://msdn.microsoft.com/library/en-us/createdb/cm_8_des_08_22lq.asp

It also should be under the "compatibility" topic, but it isn't...

Razvan

It seems that you left out a "GROUP BY R.date, R.ref" in the query. Other than this, the query is not badly written. If it is too slow, consider adding...

If he has used a strong password, indeed it can't be done. In sysxlogins it is stored only a one-way hash of the password, therefore it is not possible to...

Bob, your code is the second real attempt to solve this problem. However, it has two problems:

1. The code uses cursors (which makes it big and slow)

2. You assume that there is exactly one...

The easiest way to use GETDATE() in a UDF is to create a view that calls GETDATE() and use the view in the function.

Razvan

Phil, your code is "almost good". Try:

declare @date1 datetime
set @date1 = '20050731'
select dateadd(day,-day(@date1),dateadd(month,2,@date1))

You will get 2005-08-30 instead of 2005-08-31.

Using the same idea the code could be:

declare @date1 datetime
set...

A user defined function cannot have side effects. Quote from BOL:

"The only changes that can be made by the statements in the function are changes to objects local to the...

Patrick,

You wrote "we have to ensure that the SQL command passed to the procedure is actually a SELECT statement". I hope that you realize that the statement could be something...

I don't have a complete solution for you, but I can tell you that I thought about something similar and I encountered another problem: MS Access is using more than...

Sorry to dissapoint you, but the question seems to me much harder than you think. It is possible that I misunderstood the question, but I think that even in this...