Is there any way to increase the command timeout in DBFit?

I would like to test some complex data warehouse ETL stored procedures, but I've hit a problem as several run...

There is no way to get the SQL session running your cursor code to survive a connection failure; connection failure is of too high a severity to be trapped by...

I have seen something similar before where there is a difference in operating system localisation between the user account under which SQL Management Studio is run and the service account...

OK - I think I get it now. The reason you're missing the first few days of the month is that the "if" statement assumes you want the last few...

Sorry, I'm not clear from your answer whether the script runs every Sunday, or every Sunday plus every month end.

If I've understood correctly, run dates are the subsequent Sunday after the period being collected.

So, to use your example:

1st thru the 6th - run 7 September

7th thru the 13th -...

This code dispenses with the need to create a table variable; results are drawn directly from your table "foo" using the FOR XML clause to do the tagging.

Whilst this works...

The other thing I did (which I didn't realise was significant) was to remove the line-break in the connection string.

('SQLOLEDB', 'Trusted_Connection=yes; Integrated Security=SSPI;Server=ServerName;Initial_Catalog=master;'

Re-adding the line break causes...

You said

DataSource=ServerName

Try

Server=ServerName

Could you have the clients write the information to text files on a central file share?

A scheduled task/SQL Agent job regularly triggering an SSIS package or bcp job could...

Although the tally table solution is likely to be much more efficient for this particular task, for completeness I'll add that the way to control the limit on levels of...

Unlikely as it sounds, based on http://msdn.microsoft.com/en-us/library/ms136330.aspx (which appears to have be a complete list of ScriptType values - plus a link to Script2Type at the bottom of...

Your description of the problem is missing any rules there might be for assigning the value of Stage based on CylNo.

However, if the first two values of Stage in...