My sincerest apologies for being so pedantic - what must I have been thinking

"Unlimited" does this really SET a maximum file size ?
I know there will be a maximum file size (aka free space on disk , 2TB for a log...

If you stop the session - then drop the event - do you not have exactly the same result ?

Pissing about in the middle of the field - on a cold muddy cabbage patch - hoping for a penalty is the BRITISH way - watch the six nations...

From a purely ENGLISH Rugby Union perspective - what the H£!! is a 'TRY'.

Everyone knows that the correct way to play the game is to muck about in the...

Or the Aliens weren't really that advanced, were also taken in by the Apple publicity machine and based their OS on Apple.

Or Steve Jobs was really an Alien, sent...

Just think of it as a 'bug' in SQLs logic that you have to learn to live with

It all depends WHERE the syntax error is - whether the job will be created, how the job will run when created - the correct answer is therefore sometimes

Number of points:

I would fire

-whoever hired a DBA who " only knows how to copy and paste"!!" - as they don't sound qualified to me.

-anyone who...

As many people have said - the correct answer to the question asked was 'None of the above'.

Nit picking would apply if the correct answer was below 'None of...

try

xp_cmdshell 'dsquery group -name <group_name> |dsget group -members -expand'

and this allows for the potential to expand sub-groups

xp_cmdshell IS a correct answer

And if the Maximum Insert Commit Size in the OLEDB destination is already set to a reasonable value you.....

This option might not work - so plitting a source stream into...

I think char(1) or nchar(1) could be best but the varchar options are not best

Thanks - thought so - just not something I've actually done before