Ok, I figured this out myself. On the first page of the SQL Server 2008 setup routine there is an Options option which allows setting the architecture, once...

Now I'm just getting confused.

First of all I checked the authority on the directory containing the file and Everyone has Full Control so it can't be that.

I'm testing this on...

Well it worked like a charm on my development machine Windows XP, latest SP etc. I'm now trying to get it to work on windows VISTA machine latest SP...

Thanks for that.... it works like a charm. 🙂

hi again,

this is becoming something of an academic exercise for me, I'd really like to understand what's occurring here, and thanks to your feedback I'm learning a lot too... which...

Hi there,

Thanks for your reply.

We do try to enforce a...

The function definition:

GO

/****** Object: UserDefinedFunction [dbo].[CAP_PARM] Script Date: 12/05/2008 10:25:43 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

create FUNCTION [dbo].[CAP_PARM](@PARM_NAME varchar(8000))

RETURNS varchar(8000) AS ...

The following query generates the selectselect.jpg execution plan

select * from (Select dbo.cap_parm('SAMPLES\PARAMETERS\Month') as a) xxx

Whereas this

Select dbo.cap_parm('SAMPLES\PARAMETERS\Month')

generates the select.jpg execution plan

They both appear identical

Thanks Jonathon,

Thats what I was thinking. However I did think that a CLR routine might be quicker than SQL as it wouldn't need to need to...

Thanks for your feedback guys but I think you have both missed the point. I'm not doing simple arithmetic with the values. The lag function will return a...

Hi all,

I'm curious, my application was getting these issues (I posted a page or so back how I coded around it) It consists of a Windows service...

thanks for the update, you are correct, masking the problem is not the best solution and definitely not for an application that needs to be very responsive. However in...

I have just spent weeks trying to figure this problem out. It occurs for my app mostly when attempting an oledb connection. Using SQL Server 2005 or SQL Express...