Option 4 should read:

"Enable the feature in Enterprise <b>Manager</b> by right-clicking on Data Transformation Services | Properties and selecting the appropriate option"

Makes sense then

Use

SET DATEFORMAT 'dmy'

or similar.

Works for me

Good topic, I've had to troubleshoot one of these before.

I'd like to add one more possible cause.

The SQL Server in Q was a test server on a physically seperate LAN.

The...

A few thoughts...

Have you locked down Provider access?

That is, is "DisableAdhocAccess" set to 1 under the key HKLM\SW\MS\MSSQLServer\Providers\<provider>

If so, set it to 0

Do the ordinary users have permissions to the...

I've had to use triggers in the past to ensure domain integrity.

I agree with Antares, BOL are wrong on this.

Or I've just never figured out how to do it...

Cheers

I've had to use triggers in the past to ensure domain integrity.

I agree with Antares, BOL are wrong on this.

Or I've just never figured out how to do it...

Cheers

Sorry for the late post.

Do you mean from TSQL or via teh front end eg VB.NET.

In .NET the image datatype corresponds to a byte array.

I once captured a web cam...

8 left outer joins?

Perhaps some denormalisation is required?

Hi,

By modifying the right hand side of the OR clause to exclude the match given on the left hand side we get this

SELECT

...

Thanks for your reply

It turns out that SET XACT_ABORT ON had been issued, it was the only way to use BEGIN DISTRIBUTED TRANS, thus stoppng processing of the entire batch...