Hi,

 Thanks for the response. I've grabbed the articles and will go through them. One useful situation is that all of the data is read-only so it can take however long...

Hi,

when I'm passing data for use like this - for example when having key/value pairs with separators - e.g.,;

I use the following process;

CREATE FUNCTION Split_Varchar (@string varchar(8000),@sep varchar(1))

RETURNS...

Thanks for the assistance. I'll give it a go shortly

cheers

Andy

Hi,

So when I create an account on windows, what permissions does it need to have ? Anything specific ?

cheers for all the help btw !

Andy

Hi,

Ok, the server is set to login with "localsystem" account. I can connect to the SQL Server with Query Analyzer or Enterprise manager using a login with the system administrator...

They're running with the default install I believe. Is that what you mean ? If not, how can I find out (I'm not a DBA, more a developer !)

It seems to be consistant for particular servers now.