Thanks very much Iain, absolutely perfect! 🙂

Hi Iain,

Thanks for looking at this but it's not returning what I'm after. I want to find the largest peak to valley drop in percentage value of the account, so...

Hi Iain,

I guess to work out the drawdown you could calculate highs in equity - lows in equity and then look for the largest one and that would be the...

Thanks very much for your help. Exactly what I needed.

Thanks Oliii, that doesn't give me what I need either. I've already checked db_datareader. If I run this I get zero rows:

Select

...

Thanks, that's not quite what I'm after. I know that the user has SELECT permissions but I don't know HOW they have them. There are no explicit permissions granted to...

Thanks very much Wayne and Chris. A tally table, eh? What a nice elegant solution, thanks very much.

Thanks but from BOL it says the following:

-MaxCmdsInTran number_of_commands

Specifies the...

Hi, I solved it using an Environment Variable as described in this article http://www.mssqltips.com/tip.asp?tip=1405

Thanks for looking.

Thanks for the reply. Actually they are for SQL Server 2008 only. I did manage to find my glasses and the page to get them from is here:

Thanks for replying Chuck, your answer gave me a clue to solve the problem. In the first script task I had opened a StreamReader, but had forgotten to close it....

Thanks for your reply, what I have in detail is this:

Three parallel Data Flow tasks loading three tables from three flat files. The flat files are accessed through three Flat...

Thanks, that didn't work either. Curiously, I seem to get the error message before the remote login timeout period has elapsed. Perhaps this setting doesn't apply to bcp? I looked...

Well each parallel bcp operation is bulk copying data from a different table, so I don't think it's that. To me it sounds like a contention for server resources -...

Hi Michael, thanks for your response.

I set up the transactional publication using stored procedures like this (I declared some variables higher in the script - this is a snippet):

-- create...