If you want to see the source of a strored procedure you can also use:

sp_helptext <procname>

See sp_helptext in BOL.

Hope it will help.

Carl

Here is its answer:

>I just want to clarify something: I don't think that it is ADO.NET that

>convert anything.

>...

>>DATETIME:

>>=========

>>SqlConnection MyCnn = new SqlConnection(<ConnectionString&gt;

>>SqlCommand...

Hi also post my answer to him for the community:

I just want to clarify something: I don't think that it is ADO.NET that convert anything.

When the server...

Good idea Frank,

I will post conclusions here if we end up with.

Thank's

Carl

Frank, honestly, I would preferred a "yes" followed by a "why".

We are using ADO.NET and those dynamic SQL are "generated" by ADO.NET and, for...

It seem that the server uses the same exec plan in the tests I've done.

But, for sure, one of those two method may incur, at least, a little overhead. No?

Regards,

Carl

Hello Chris,

Just to make it clear my goal is not to have this machine out off the domain.

Yesterday I put it out of the domain for test pupose only (to...

Thank's Chris,

this is not a hurry but I appreciate all you are doing to clarify this topic.

Carl

Hi again Chris,

To be sure, I put the server out of the domain (even if we are sure that it is set to NOT DEFINED for the OU and it...

Hello Chris,

The machine is not our domain controller.

Since I see that the Effective Setting for the "Passwords must meet complexity requirements" is set to Disabled, it is because it inherit...

Is is not defined at the domain level nor it is at the O.U. for the servers (active directory).

The proof is that I can see that, for this setting the Local Setting...

It is already set to disabled.

So it seem that my problem is not related to this setting.

Carl

Thank's Steve,

We've noticed that yesterday in our tests.

Hope the trace flag wont be needed on the next version of SQL Server.

Hope also that SNAPSHOT ISOLATION LEVEL will become more transparent...

Hello Chris,

is it a setting of SQL Server or a setting of the OS?

I don't find something called "LocalSecurity policy" in BOL.

Thank's

Carl

Thank's for the info David, I will take a look at that.

Have a nice day,

Carl